Z
zzzmz
Guest
CAN I DISPLAY A LIST OF ALL TABLES IN MY ACCESS DATABASE ON A FORM?
princess15s
Registered User.
- Local time
- Today, 21:20
- Joined
- Aug 2, 2001
- Messages
- 15
yes you can,
What do you want to do?
1)Just display them? or
2)do you want to open them using the form as well as displaying them?
To do 1) all you have to do is click on label on the toolbox and drag it down to the form and type the names of the table.
to do no.2)
Create macro
Action: OpenTable
Action Argument, Table Name: "Your Table Name"
Save it and In your form create a command button and MISCELLANIOUS, RUN MACRO, select the macro you've created and finish.
hope this helps.
What do you want to do?
1)Just display them? or
2)do you want to open them using the form as well as displaying them?
To do 1) all you have to do is click on label on the toolbox and drag it down to the form and type the names of the table.
to do no.2)
Create macro
Action: OpenTable
Action Argument, Table Name: "Your Table Name"
Save it and In your form create a command button and MISCELLANIOUS, RUN MACRO, select the macro you've created and finish.
hope this helps.
Z
zzzmz
Guest
Actually as part of my program several users will be exporting tables into an access database. I would like to display all tables in the database to see if all tables have been imported. The list of tables will be constantly changing. Can I diplay this on a form?
Thanks
Thanks
- Local time
- Today, 16:20
- Joined
- Feb 19, 2002
- Messages
- 46,920
Please don't post the same question under multiple topics.
princess15s
Registered User.
- Local time
- Today, 21:20
- Joined
- Aug 2, 2001
- Messages
- 15
Hiya, I really don't know how you could do that, but I guess you would be able to do it with Visual basic and I have no clue when it comes to visual basic. Sorry but go to this site: www.wopr.com and you could get help from them.
Goodluck.
Goodluck.
joeyreyma
MSCEmbalmer
- Local time
- Today, 21:20
- Joined
- Jul 3, 2001
- Messages
- 78
Loop through all the members of the Tabledefs collection. eg:
Public Sub ListTables()
Dim tbl As TableDef
For Each tbl In CurrentDb.TableDefs
Debug.Print tbl.Name
Next
End Sub
this one displays all tables in the debug window, just customize it to your needs.
Public Sub ListTables()
Dim tbl As TableDef
For Each tbl In CurrentDb.TableDefs
Debug.Print tbl.Name
Next
End Sub
this one displays all tables in the debug window, just customize it to your needs.
D
DJN
Guest
If you only want to display a list of tables in the database, copy and paste this SQL statement into the Row Source of your list box.
SELECT MSysObjects.Name FROM MsysObjects WHERE (Left$([Name],1) <> "~")
AND (MSysObjects.Type)= 1 ORDER BY MSysObjects.Name;
SELECT MSysObjects.Name FROM MsysObjects WHERE (Left$([Name],1) <> "~")
AND (MSysObjects.Type)= 1 ORDER BY MSysObjects.Name;
- Local time
- Today, 16:20
- Joined
- Feb 19, 2002
- Messages
- 46,920
People seem to want to keep trying to solve this problem even though it has already been solved. Please see: http://www.access-programmers.co.uk/ubb/Forum2/HTML/001045.html
And again I ask you ALL to not post the same question under multiple topics.
And again I ask you ALL to not post the same question under multiple topics.
Similar threads
