Where Used

[Letkowski]

Is there a "Where Used" in Access? I am trying to develop one. I have a
field called 'candy bar' and I want to know everywhere that it is used,
i.e., which forms, reports, and queries use 'candy bar'. I have code to
scan queries and it has returned 3 queries that reference 'candy bar'. Now
how do I scan forms and reports to find where those 3 queries are used?
Other than scanning queries, how do I scan forms and reports to find out
where the field, 'candy bar', is used.
As a manual alternative, can I use "Finds" to accomplish the same as above?

I can send the code to scan queries if anyone is interested

 

[Douglas J. Steele]

While it's possible to roll your own, I think you'd be best off purchasing a
3rd party product.

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

Other possibilities are
Find & Replace: http://www.rickworld.com/products.html
Speed Ferret: http://www.moshannon.com/speedferret.html

 

[SA]

Another, less costly option to the Total Access Analyzer for Find and
Replace action is Rick Fisher's Find and Replace for Access, its cheap and
works great (has since Access 2). You'll find it at
www.rickworld.com/products