Access Utility that shows which forms/reports are using which quer

[Guest]

Hello -

I have some queries that I am sure I am no longer using but would like to
verify that before I delete them.

Is there a way to view a report that shows which queries are being used by
which forms/reports? I tried the Tools -> Alanyze -> Documenter, but it does
not show this.

thanks!
Sandy

 

[Bill Mosca, MS Access MVP]

I use a freeware add-in called V-Tools. You can get it at www.skrol29.com

One of the features is a deep search. You can search through the entire
database for teh query name and it will show you all the objects and code
that use it.

 

[Guest]

Rich Fisher's excellent Find and Replace add-in might be just the ticket. If
you register it (one of the best $37 I've ever spent), the cross-reference
report can find what queries use which reports and forms. It's a good way to
find orphans.

http://www.rickworld.com/

 

[Guest]

Thanks to Bill and Jerry for their great tips!