Viewing available tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
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));
 
Back
Top