Query List

  • Thread starter Thread starter Mark
  • Start date Start date
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?
 
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;
 
Back
Top