If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
tracking from a query to a table
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 |
#2
|
|||
|
|||
tracking from a query to a table
On Wed, 27 Jan 2010 15:24:01 -0800, Jacqueline
wrote: 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/acc...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/ -- John W. Vinson [MVP] |
#3
|
|||
|
|||
tracking from a query to a table
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. "Jacqueline" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|