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.
LVL 4
Keyboard CowboyAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

CodeCruiserCommented:
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
0
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.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
0
Dale FyeOwner, Developing Solutions LLCCommented:
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.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.