Query List

[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?

 

[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?

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;