Viewing available tables

S

Steve Hughes

Hi, is there anyway I can have a list of the available tables displayed in
either a combo or list box within a form so I can select one and have the
table name stored in a text string?

Cheers

Steve
 
K

kingston via AccessMonster.com

Tools -> Options - Show System Objects
Look in MSysObjects for Types 5 (tables) and 6 (linked tables).
You can reference this table in your queries and code.
 
D

Duane Hookom

Set the Row Source to something like:

SELECT msysobjects.Name, msysobjects.Type
FROM msysobjects
WHERE (((msysobjects.Name) Not Like 'msys*') AND ((msysobjects.Type)=1 Or
(msysobjects.Type)=6));
 
Top