List if Queries

  • Thread starter Thread starter rblivewire
  • Start date Start date
R

rblivewire

I am trying to put a button on a form that gives the user a complete
list of already made queries to choose from. I know there is an option
to select individual queries, but is there an option to display the
whole list? The user can browse down this list and click on the query
that they wish to run. Any suggestions???
 
Why not give them a list box that shows them all?

Use the following SQL as its RowSource:

SELECT Name FROM MSysObjects WHERE Type=5 AND LEFT$([Name], 3) <> "~sq"
ORDER BY Name
 
Try this

SELECT MSysObjects.Name, MSysObjects.Flags
FROM MSysObjects
WHERE (((MSysObjects.Type)=5) AND ((MSysObjects.Flags)<>3))

Note: You can use the Flags field to seperate between the queies type.
Update or select.
 
Back
Top