• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 217
  • Last Modified:

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.
Keyboard Cowboy
Keyboard Cowboy
1 Solution
If you select the form and then in Database Tools ribbon, click on Object Dependencies, does it work?

Otherwise, try


EirmanChief Operations ManagerCommented:
You can search through all code for all forms/modules in the one go.

Before you finally delete anything, rename it,
so rename ......
Form1 to DELETEForm1      Form3 to  DELETEForm3    SubFormX  to DELETESubFormX
Query4 to DELETEQuery4        ditto for reports etc.

Then run/test every aspect of the database and you will soon find anything you erroneously marked for deletion.

Keep a copy of the original db and you can import individual forms etc. if you need them in the future.
Keyboard CowboyAuthor Commented:
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 FyeCommented:
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.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now