Where Used

L

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
 
S

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
 
Top