UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> how 2 use RECORDSET?    
 
   
JinaneKarhani
post Sep 26 2004, 09:48 PM
Post #1

New Member
Posts: 17
Hello there,
I’ve been told that I can use the “Recordset” & “Recorset Type” in order to create table with multiple same type fields but with different captions, & in order to do this I must add the ADO 6 or DAO 6 library , how? I don’t how to add the ADO or DAO 6 for only I havr the version 5.1, so from where can I download it ??? & can anyone give me the structure of the recordset by an example ? This would be soooo much help 4 me.
Jinane
Go to the top of the page
 
+
Jerry Dennison
post Sep 26 2004, 11:09 PM
Post #2

Head Wizard
Posts: 14,857
From: South Carolina, USA
Welcome to UtterAccess!

Why would you want to create multiple same type fields? What exactly do youmean by this? Can you post the structure you wish to accomplish?
Go to the top of the page
 
+
JinaneKarhani
post Sep 27 2004, 10:05 PM
Post #3

New Member
Posts: 17
ok, thx Jerry here's the table structure
i have an autonb field
a field "A" text 4
Nb of fields (this depends from other table RECORDS) X with Nb-->integer type
A field Note As Text 130

..
i will create a nb of tables like this but each time this X will change.
Go to the top of the page
 
+
Jerry Dennison
post Sep 27 2004, 10:51 PM
Post #4

Head Wizard
Posts: 14,857
From: South Carolina, USA
What do you mean by 'nb'?
Go to the top of the page
 
+
JinaneKarhani
post Oct 1 2004, 08:07 AM
Post #5

New Member
Posts: 17
nb is for number
Go to the top of the page
 
+
Jerry Dennison
post Oct 1 2004, 09:21 AM
Post #6

Head Wizard
Posts: 14,857
From: South Carolina, USA
That's what I thought. Why would you want to create multiple tables for the same entity? This is not only uneccessary, but will make management of the database almost impossible (not to mention make it almost impossible to get any kind of meaningful information back out of the database).
Go to the top of the page
 
+
JinaneKarhani
post Oct 1 2004, 09:10 PM
Post #7

New Member
Posts: 17
ok, i'll change my analysis may be..
thx Jenny..

..HarunYahya.com An inviation to the Truth..
Go to the top of the page
 
+
Jerry Dennison
post Oct 1 2004, 10:31 PM
Post #8

Head Wizard
Posts: 14,857
From: South Carolina, USA
You're welcome. Good Luck!

You can find more information on the Normal Forms in the Access FAQA Forum.
Go to the top of the page
 
+
JinaneKarhani
post Oct 4 2004, 07:04 AM
Post #9

New Member
Posts: 17
thx Jerry..
Go to the top of the page
 
+
« Next Oldest · Access Macros · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 22nd May 2013 - 12:07 PM