List all Forms, Query, Report for a given field

[Les]

Is there a simple way to list all the Forms, Queries and report for a given
database that a field is used in. I need to change where this field currently
comes from.

 

[John W. Vinson]

Is there a simple way to list all the Forms, Queries and report for a given
database that a field is used in. I need to change where this field currently
comes from.

There are some good third-party tools to do this:

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

John W. Vinson [MVP]

 

[Jeff Boyce]

Les

In addition to free tools (try an on-line search), FCS, Inc. has SmartAccess
and BlackMoshannon has SpeedFerret (both are COTS, for a price-- I've used
both).

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Jeff Boyce]

Thanks, John... that should have been Total Access Analyzer from FMS...

Regards

Jeff Boyce
Microsoft Office/Access MVP