How do I find all uses of a field in Access (Queries, Form/Report SQLs, VB, etc) ?

[Jeffrey Ross]

I've inherited a database with 3 main tables, each of which have a Status
field, but the Statuses in one table don't match those in the others and I
need to extend one table's statuses even further. Unfortunately there are
Macros, Form/Report SQLs, Queries, and Visual Basic code that use hard-coded
Status values, and in some places rely upon those Status values being in a
particular order.
Is there any way that I can scan the whole of an Access database including
the various Visual Basic modules to find "Status"? At present it seems that
I need to open each Form and check the property of each control to see if
"Status" is used in it, and similarly for each Macro, Query, and VB module.
Surely there's an easier way?
TIA
Jeffrey

 

[Douglas J. Steele]

Take a look at FMS's Total Access Analyzer
http://www.fmsinc.com/products/analyzer/index.html

 

[Guest]

I use Speed Ferret:

http://www.speedferret.com/sysreqmts.html

And when I locate people who have put together databases like you discribe,
I use Winchester