locating query's use

[Russ]

Does anyone know of a siimple way to find out what report/form is
using a particular query without going through them all one at a time?
I've got a simple query that I think need modifying, and if I could
locate which other item calls it I could determine whether it is safe
to change or not.

 

[John W. Vinson]

Does anyone know of a siimple way to find out what report/form is
using a particular query without going through them all one at a time?
I've got a simple query that I think need modifying, and if I could
locate which other item calls it I could determine whether it is safe
to change or not.

I don't think there's a builtin way in Access to do this, but there are some
third-party tools that can help. Free:
http://www3.bc.sympatico.ca/starthere/findandreplace
Find and Replace: http://www.rickworld.com
Speed Ferret: http://www.moshannon.com
Total Access Analyzer: http://www.fmsinc.com

I know the "Find and Replace" from rickworld.com is still available; it's not
free but worth the modest price (and comes with a 30 day free trial).
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com

 

[Russ]

Thanks John, I'll check it out.

I don't think there's a builtin way in Access to do this, but there are some
third-party tools that can help. Free:
http://www3.bc.sympatico.ca/starthere/findandreplace
Find and Replace: http://www.rickworld.com
Speed Ferret: http://www.moshannon.com
Total Access Analyzer: http://www.fmsinc.com

I know the "Find and Replace" from rickworld.com is still available; it's not
free but worth the modest price (and comes with a 30 day free trial).

 

[David-W-Fenton]

Does anyone know of a siimple way to find out what report/form is
using a particular query without going through them all one at a
time? I've got a simple query that I think need modifying, and if
I could locate which other item calls it I could determine whether
it is safe to change or not.

If you turn on Name AutoCorrect, it will build the table of
dependencies and you should then be able to see where the query is
used. However, this will only work for saved queries, for
Recordsources in reports/forms and for rowsources in combo/listboxes
-- it won't find any use of the query in VBA code. But you could
just do a search in the VBE and search the entire project.

Once you're done with this, you'd want to turn off Name AutoCorrect,
as it can lead to all sorts of problems in production use.

 

[Sissa Jones]

Does anyone know of a siimple way to find out what report/form is
using a particular query without going through them all one at a time?
I've got a simple query that I think need modifying, and if I could
locate which other item calls it I could determine whether it is safe
to change or not.

Russ - I usually run the database documentor and then export to Word -
there you can use find for anything to see if it's used not only in
the queries but in modules or macros too - then you have the basis for
your index and data dictionary - magic!

Hope this helps
Sissa - from a remote island in the South Pacific