J
JG
I have a listbox on a form and I want to populate it with
the names of all of the queries in the database. Right
now I have it set to show the names of all the tables. I
know that the syntax is:
SELECT [Name]FROM MSysObjects WHERE [Type] = 1
The number 1 is the code for the table names. What is the
number for the query names??
Thanks in advance,
John G
the names of all of the queries in the database. Right
now I have it set to show the names of all the tables. I
know that the syntax is:
SELECT [Name]FROM MSysObjects WHERE [Type] = 1
The number 1 is the code for the table names. What is the
number for the query names??
Thanks in advance,
John G