How can I print a list (or file) of all query names used?

[Guest]

The Documenter forces one page for each query. I would like to print (or
make a file) of all of the queries contained in a large database. With a
list like this (in excel for example) I could begin the task of cleaning up
the names and obsolete queries.

I am an experienced user. XP Pro, Office Pro 2003. Can I do this with a
vba module?
Thanks
Len Robichaud
(e-mail address removed)

 

[Douglas J Steele]

Is all you want a list of the query names?

SELECT Name
FROM MSysObjects
WHERE Type=5
ORDER BY Name

 

[Guest]

Thanks, this worked perfectly. Can you recommend some reading so I can know
and understand more of this sort of information? Working with the system and
hidden files?

 

[Roger Carlson]

You might want to take a look at Rick Fisher's Find and Replace, found here:
http://www.rickworld.com/download.html

It will make your work a lot easier. BTW, if you register the product you
get some nifty features that the shareware version doesn't have. Well worth
it.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Douglas J. Steele]

Not really, because the system files are officially undocumented.