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

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.

--
Bill Mosca, MS Access MVP


"Sandy" <(E-Mail Removed)> wrote in message
news:0806F915-BDD0-48E6-A9BC-(E-Mail Removed)...
> 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

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/
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Sandy" wrote:

> 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

Thanks to Bill and Jerry for their great tips!