Prev: Shared Data Types
Next: training database - required training per employee
From: Jacqueline on 27 Jan 2010 18:24
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
From: John W. Vinson on 27 Jan 2010 21:18
On Wed, 27 Jan 2010 15:24:01 -0800, Jacqueline
<Jacqueline(a)discussions.microsoft.com> 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/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/

--

John W. Vinson [MVP]
From: Jeff Boyce on 28 Jan 2010 08:55
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" <Jacqueline(a)discussions.microsoft.com> wrote in message
news:2835C580-851B-4655-AF78-4333B165B9AF(a)microsoft.com...
>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


 | 
Pages: 1
Prev: Shared Data Types
Next: training database - required training per employee