Display / Print List of Queries

Topic

New Reply

I have about 200 queries (and reports and macros…) in an Access 2000 DB. I would like to be able to display or print a list of their names. How would I do that?

Thanks!

JoeK

Reply | Quote

Replies

You can use the built in database documentor in database utilities

Reply | Quote

I have about 200 queries (and reports and macros…) in an Access 2000 DB. I would like to be able to display or print a list of their names. How would I do that?

You can also use this query:

Select MsysObjects.Name FROM MsysObjects WHERE MsysObjects.Type=5 AND msysobjects.Name Not Like “~*” ORDER BY msysobjects.Name;

Reply | Quote

You can also use this query:

Select MsysObjects.Name FROM MsysObjects WHERE MsysObjects.Type=5 AND msysobjects.Name Not Like “~*” ORDER BY msysobjects.Name;

Thanks! I didn’t know about the Documenter (which I tried), but I think that for my purposes, this query does the trick.
See, learn something new every day.

JoeK

Reply | Quote

Thanks! I didn’t know about the Documenter (which I tried), but I think that for my purposes, this query does the trick.
See, learn something new every day.

Yeah, the built-in Documenter tends to give you more information than you need, with no way to limit it. That’s why I created my own Table Documenter which is part of my Liquorman Utilities. I might consider adding a Query Documenter to it!

Reply | Quote