var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Print List of Queries
Is there a way to print out a list of the existing queries in a database. I have over 200 queries and it would make it easier to have a reference.
Try using the Documenter, which is found under Tools -Analyze - Documenter. Select Queries then select all - OK.
This will give you the Query name, properties,SQL,Any Parameters and columns.
If you only want the names of the queries, just put this code in the RecordSource of the textbox in the report.
SELECT [Name] FROM MsysObjects
WHERE (([Type] = 5) AND ([Name] Not Like "~*") AND ([Name] Not Like "MSys*"))
ORDER BY [Name];