Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Utility to search whether a component is used or not

Discussion in 'Information Technology' started by Traci, Jul 28, 2006.

  1. Traci

    Traci
    Expand Collapse
    Guest

    Is there a utility in Access that will cross reference a component name to
    see if it is used in the application or not? For example, I've got a bunch
    of macros that I don't think are used, but it would take me all day to go
    through each form, query etc. to determine if they are using these macros.

    Thanks
     
  2. Loading...

    Similar Threads Forum Date
    Gurmat Vichaar | Futility Of Counting Paaths | April 12, 2016 Gurmat Vichaar Apr 23, 2016
    USA 2 Sikhs shot dead in US utility store Breaking News Sep 8, 2013
    Sikh News Futility Takes a Holiday Breaking News Mar 4, 2005
    Sikh News Indian American Couple Donates For Sikh, Punjabi Culture Research In US Breaking News Aug 19, 2016
    Soul Search By Swarn Singh Bains Book Reviews & Editorials May 25, 2016

  3. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    Take a look at FMS's "Total Access Analyzer"
    http://www.fmsinc.com/products/analyzer/index.html

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)


    "Traci" <Traci@discussions.microsoft.com> wrote in message
    news:86CF42A8-73DE-493E-BC5F-9EAD6D5B450C@microsoft.com...
    > Is there a utility in Access that will cross reference a component name to
    > see if it is used in the application or not? For example, I've got a

    bunch
    > of macros that I don't think are used, but it would take me all day to go
    > through each form, query etc. to determine if they are using these macros.
    >
    > Thanks
     
  4. '69 Camaro

    '69 Camaro
    Expand Collapse
    Guest

    Hi, Traci.

    > Is there a utility in Access that will cross reference a component name to
    > see if it is used in the application or not?


    Not really. The closest to that in Access 2003 is the "Object Dependencies"
    feature, but it doesn't track macros. However, it may help you with other
    objects you have created. If you have Access 2003, then make a copy of your
    database file. In this copy, turn the "Track name AutoCorrect Info" option
    on, then right-click on the name of the object in the Database Window and
    select "Object Dependencies..." in the pop-up menu, and you'll get a list of
    dependencies for this object.

    If you have an earlier version of Access, then use the built-in Documenter
    Wizard and output the report to Excel, then search through that for the
    names of your objects to determine whether they are used in other objects,
    such as a control on a form.

    HTH.
    Gunny

    See http://www.QBuilt.com for all your database needs.
    See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
    http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
    info.


    "Traci" <Traci@discussions.microsoft.com> wrote in message
    news:86CF42A8-73DE-493E-BC5F-9EAD6D5B450C@microsoft.com...
    > Is there a utility in Access that will cross reference a component name to
    > see if it is used in the application or not? For example, I've got a
    > bunch
    > of macros that I don't think are used, but it would take me all day to go
    > through each form, query etc. to determine if they are using these macros.
    >
    > Thanks
     
  5. Larry Daugherty

    Larry Daugherty
    Expand Collapse
    Guest

    There are at least two utility programs that could help. I believe
    that John Nurick listed another recently:

    Find and Replace from Rick Fisher at www.rickworld.com shareware
    Speed Ferret from moshannon.com commercial

    Both get good recommendations.

    HTH
    --
    -Larry-
    --

    "Traci" <Traci@discussions.microsoft.com> wrote in message
    news:86CF42A8-73DE-493E-BC5F-9EAD6D5B450C@microsoft.com...
    > Is there a utility in Access that will cross reference a component

    name to
    > see if it is used in the application or not? For example, I've got

    a bunch
    > of macros that I don't think are used, but it would take me all day

    to go
    > through each form, query etc. to determine if they are using these

    macros.
    >
    > Thanks
     

Share This Page