List Objects

[aardvark]

Is there a utility/routine available that will list the objects in a database, specifically the queries and reports? TIA.

[HansV]

To list the names of all queries, you can create a query with this SQL:

SELECT [Name]
FROM MsysObjects
WHERE (([Type] = 5) AND ([Name] Not Like "~*") AND ([Name] Not Like "MSys*"))
ORDER BY [Name];

and use it as the row source for a list box or combo box, or the record source for a form or report.

For reports, change the SQL to

SELECT [Name]
FROM MsysObjects
WHERE (([Type] = -32764) AND ([Name] Not Like "~*") AND ([Name] Not Like "MSys*"))
ORDER BY [Name];

Others: Tables have type 1, Forms have type -32768 and Modules have type -32761.

[aardvark]

Thanks, Hans. Just what I needed.