Query List

[JudyHNM]

I am using Access 2016, Window 10. Is there a way to get a list of all the queries in the database? Also, is there a way to find out where each query is used and print a report?

Thanks, Judy

 

[isladogs]

To get a list of queries, use this:

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

Not clear exactly what you mean by 'where each query is used'
Try using Object Dependencies in Database Tools

 

[JudyHNM]

To get a list of queries, use this:

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

Not clear exactly what you mean by 'where each query is used'
Try using Object Dependencies in Database Tools

Sorry. I mean a list of all the reports and/or form used by the query.

 

[JudyHNM]

To get a list of queries, use this:

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

Not clear exactly what you mean by 'where each query is used'
Try using Object Dependencies in Database Tools

oops - forgot to thank you for the code to list all the queries. It worked perfectly.