tracking from a query to a table

[Jacqueline]

I have a table that contains codes for our distance learning classes. Our
state is getting ready to make a massive change to these codes.

I know I have queries that support reports and forms based on these codes.
Is there a way to track from the table to each query, form, or report that
the codes is used?
Any help here will really save me a lot of hours tracking this stuff down or
waiting until something breaks.

Thanks
Jacqueline

 

[John W. Vinson]

I have a table that contains codes for our distance learning classes. Our
state is getting ready to make a massive change to these codes.

I know I have queries that support reports and forms based on these codes.
Is there a way to track from the table to each query, form, or report that
the codes is used?
Any help here will really save me a lot of hours tracking this stuff down or
waiting until something breaks.

Thanks
Jacqueline

You may want to get one of the third-party programs which help document and
crossreference Access databases:

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

Not all of these support A2007, and some may not be available anymore (my list
is rather old). Some more general resources (which may link to other such
programs) are at

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

Roger Carlson's tutorials, samples and tips:
http://www.rogersaccesslibrary.com/

 

[Jeff Boyce]

Jacqueline

Are you saying that your "queries, forms, and reports" rely on the values in
the table, rather than the fields (i.e., field name)? If so, could you
describe a bit more about how you're doing that?

--

Regards

Jeff Boyce
Microsoft Access MVP

Disclaimer: This author may have received products and services mentioned in
this post. Mention and/or description of a product or service herein does
not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.