Report of Reports?

[sts023]

Hi guys, it's that irritating Newbie again!

Does anyone know how I can generate a Report (or a Query for that matter) which will list the name(s) of the Objects (Reports, Queries, Tables etc.) present in a database?

I'd like to be able to generate, say, a list of Modules within the database, but the only options I seem to have as a "source" for the data is Tables or Queries, and I don't want to put the names of all of the Modules in a Table!.

Has anyone got a cunning method?

 

[vbaInet]

The MSysObjects table holds a list of all Access Objects. Here's an example for getting all queries:

SELECT MSysObjects.Name, MSysObjects.Type
FROM MSysObjects
WHERE Not Left([Name], 1)="~" AND MSysObjects.Type = 5;

For the other objects, remove the criteria and you will be able to work what to set the criteria to.