G Gulf Coast Electric Oct 16, 2003 #1 I need to use a form to show a drop down list of the tables in my database. What is the syntax for the query Please. Thanks, Dave
I need to use a form to show a drop down list of the tables in my database. What is the syntax for the query Please. Thanks, Dave
A Allen Browne Oct 16, 2003 #2 SELECT MSysObjects.Name FROM MSysObjects WHERE Type = 1 AND Not (Name Like "MSys*" Or Name Like "~*") ORDER BY MSysObjects.Name;
SELECT MSysObjects.Name FROM MSysObjects WHERE Type = 1 AND Not (Name Like "MSys*" Or Name Like "~*") ORDER BY MSysObjects.Name;