asked on

Access map or diagram of forms

I have an Access application with dozens of forms (all with code) and a retired original developer. I'm pretty sure not all of the forms are used and I could reduce the size of my Access Front End by deleting them. Is there a way to get a map of what form invokes what other forms. The only solution I have to so far is the export ALL of the code (37K lines) throughout the application and search for open form lines - other solutions? Thanks in advance (as many of you know by now, I can't install a custom app on this network but I can take an existing Access app with code and import it into the network I'm on.

Nasir Razzaq

If you select the form and then in Database Tools ribbon, click on Object Dependencies, does it work?

Otherwise, try

http://www.aadconsulting.com/obdepoff.html

http://www.rickworld.com/products.html

ASKER CERTIFIED SOLUTION

Eirman

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Fredd

ASKER

I tried the track comments but after running an hour I stopped it (and it doubled the size of my database by then).
Yeah, I never delete anything until I throughly test and I backup about every 30 minutes (when editing VBA, access can suddenly lose the modules I've found upon re-opening the database despite compact/repairs.
Thanks for the input

Dale Fye

You might take a look at Total Access Analyzer although this might be overkill.

You could also look into Rick Fisher's Find and Replace, which would let you search for form names and would identify everywhere in your database, other forms, code modules, reports, queries, macros which reference that form. This application is a must-have for any serious developer.