Query List

M

Mark

Hi All,

I'm trying to make a form that shows a list of queries presently in my
database. How do I go about creating a list from queries that reside in my
db?
 
F

fredg

Hi All,

I'm trying to make a form that shows a list of queries presently in my
database. How do I go about creating a list from queries that reside in my
db?
Click to expand...

To show all the named queries in the current database, add a listbox
control to your form.
As ListBox rowsource:

SELECT MSysObjects.Name
FROM MSysObjects
WHERE (((Left([Name],1))<>"~") AND ((MSysObjects.Type)=5))
ORDER BY MSysObjects.Name;
 
Top