How to find where a field name is used

[Guest]

Is there any way to find (list) all the forms, reports, and/or queries that
use field name fld1 of table tbl1? One option is to open every object and
look at it. Not fun.

Steve

 

[Guest]

Hi Steve,

Speed Ferret: http://www.moshannon.com/speedferret.html

Total Access Analyzer can also help you with this task:
http://www.fmsinc.com/products/analyzer/index.html

While these tools are not free, they are very good. TAA can help you
pinpoint all kinds of problems.

I'm not sure, but I think Access 2003 might (?) have this feature built-in,
but it would require the NameAutocorrect option to be set. I'm still using
Access 2002 at home, and have just started using Access 2003 at work. Since
I'm not at work today, I cannot verify whether this feature just helps to
identify where a table or query is used, or if it works at the field level.

Other possible alternatives include the following, but I do not have
experience using any of them:

Find & Replace: http://www.rickworld.com/products.html
(Shareware with 30 day evaluation period)

Ucora:
http://www3.bc.sympatico.ca/starthere/findandreplace/
(Free)


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

:

Is there any way to find (list) all the forms, reports, and/or queries that
use field name fld1 of table tbl1? One option is to open every object and
look at it. Not fun.

Steve

 

[Larry Linson]

Is there any way to find (list) all the forms,
reports, and/or queries that
use field name fld1 of table tbl1? One option is to
open every object and look at it. Not fun.

There are third-party products that do this for you. One I have used and
liked is Speed Ferret from Black Moshannon Systems,
http://www.moshannon.com. Another is Find And Replace from Rick Fisher
Software, http://www.rickworld.com -- many think well of this one, too.

There are likely other good ones, too, of which I am unaware. I don't have
any business relationship with either, except as a user of the product.

Larry Linson
Microsoft Access MVP