Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Feb 2003
    Posts
    120
    Thanks
    3
    Thanked 2 Times in 2 Posts

    Forward references in Access 2007 (pro)

    Is there some way to see where items (fields, tables, queries, ...) are used within an Access application?

    I have a modestly complicated Access system, and forget where fields, and other items, are used within the application. This means that when I make a change, I may be fouling up something further along in the processing stream, because I don;t remember all the places where that item is used. So I'm hoping that there is something like a concordance function that would show me where things that are generated within the application are used (similar to what one can do in Excel).

    Thanks for any help!

    Bob Chapman

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Forward references in Access 2007 (pro)

    Rick Fisher's Find and Replace for Microsoft Access has a cross reference tool that shows where items are used. The Access 2007 version is still in beta, though. Find and Replace is not free but well worth the modest price.

  3. #3
    2 Star Lounger
    Join Date
    Feb 2003
    Posts
    120
    Thanks
    3
    Thanked 2 Times in 2 Posts

    Re: Forward references in Access 2007 (pro)

    Thanks, Hans.
    Bob

  4. #4
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Jerusalem, Israel
    Posts
    708
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Forward references in Access 2007 (pro)

    Another option that is much more expensive is FMS Total Access Analyze ,but it does what you need and a lot more. I have used it http://www.fmsinc.com/MicrosoftAcces...Practices.html

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •