Utility: Which fields have been accessed by a program ??

Posted on 2006-04-07
Last Modified: 2010-05-01
Is there a utility that can tell me which data items in my programs have been used after I run the programs?


Question by:cmmcginn
    LVL 8

    Expert Comment

    None that I know of, but, what I've done in the past is use the On_Change event of the controls I wish to monitor and then write their names to an array.  I currently have a program in the works that monitors text boxes for a change and if one is changed, enables a save button.

    It's a bit ugly, but it works.


    Author Comment

    I see.  I was actually thinking about monitoring the use of variables, constants, etc. that are in my programs.


    LVL 14

    Accepted Solution

    You could use a project analyzer like e.g.

    Some you can try out for 30 days, just see which one you like.

    Author Comment

    Thanks.  I'll take a look.

    LVL 9

    Expert Comment

    Looks to me like Project Analyzer finds dead code, that is, subs that are not called from anywhere in the program, variables that are declared but not assigned, but it does this by static analysis of the code.  Doesn't matter how many times or ways one runs the program, dead code will never execute

    My reading of the questions is that he's looking for coverage analysis, that is, during a given run of a program which subs were called, which variables assigned and which were not.  If Project Analyzer does that, great, if not, I'd like to know what tool does.

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Join & Write a Comment

    Suggested Solutions

    If you have ever used Microsoft Word then you know that it has a good spell checker and it may have occurred to you that the ability to check spelling might be a nice piece of functionality to add to certain applications of yours. Well the code that…
    When designing a form there are several BorderStyles to choose from, all of which can be classified as either 'Fixed' or 'Sizable' and I'd guess that 'Fixed Single' or one of the other fixed types is the most popular choice. I assume it's the most p…
    Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
    Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

    731 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now