|
| |
|
|
accessman
Posts: 74
Joined: 9/13/2005
Status: offline
 |
Retrieve all the table names - 6/28/2006 18:53:12
Hi:
In the database, I want to create a combox in the form, it the dropdown list show all the table names I created, or linked.
I don't want to create a table to store the table names.
Can we retrieve the table names from the Tables sections directly?
Thanks.
|
|
|
|
accessman
Posts: 74
Joined: 9/13/2005
Status: offline
|
RE: Retrieve all the table names - 6/29/2006 0:16:50
Not ASP.
I want to work with MS Access forms, Visual Basic in the MS Access Forms.
Can we use ADO to make it ?
Thanks.
| |
|
|
|
rdouglass
Posts: 9280
From: Biddeford, ME USA
Status: offline
|
RE: Retrieve all the table names - 6/29/2006 9:13:43
Well, I'm not sure how to do it within Access it self but this SQL *should* return the list of all tables and views regardless of how you send it to Access:
SELECT MSysObjects.* FROM MSysObjects
That help any?
_____________________________
Don't take you're eye off your final destination.
ASP Checkbox Function Tutorial.
| |
|
|
|
accessman
Posts: 74
Joined: 9/13/2005
Status: offline
|
RE: Retrieve all the table names - 6/30/2006 12:13:15
Thank you.
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
