asked on

Access 2007 - Want to See Hierarchy of Forms and the Controls They Contain

I'm using Access 2007. Is there a tool that would show all the controls contained within one form, and if the form has a subform, the controls contained within the subform? Also, whether the controls are contained in the header, detail, or footer sections.
I'm looking for a tool that would print out something like shown below. It would help me prepare documentation for myself and other developers.

frmMenu

- Header
- lblTitle

- Detail
- cmdSave
- lblRecordNumber
- txtCustomerName
- subFormOrders
- lblOrderDate
- txtOrderDate

- Footer
- lblDate

ASKER CERTIFIED SOLUTION

Gustav Brock

membership

This solution is only available to members.

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

Start Free Trial

Curtis Blaine

ASKER

Thanks for letting me know. I'm using Access 2007. Will it analyze .mdb databases (as opposed to .accdb)?

Gustav Brock

I guess so. If not (see left column), versions for as early as Access 97 are still available.

/gustav

Curtis Blaine

ASKER

Hi Gustav,
I downloaded the Total Access Analyzer 2007 Demo. When I run the file "TAADemo.accde"
I get an error message "The database is in an unrecognized format". I see that the directory
contains the file "Northwind.tdb".

I sent an e-mail to FMS Tech Support but have not heard back.

Any suggestions?

Thanks!

Curtis Blaine

ASKER

Hi Gustav,
You can ignore the last comment. I installed the Total Access Analyzer 2007 Demo on another PC and I was able to get it to work.
But I have another question. Perhaps the TAA documentation answers it, but maybe you know the answer. Question: Can I see what forms contain a certain subform? I used the demo and selected the subform in the Treeview list on the left, but the reports did not seem to show what forms contain the subform.

Thanks!

Gustav Brock

That would be XRef:

Cross-Reference: XRef
The XRef tab shows for each object, where it's used throughout your application including references from other objects, macros, and modules.

/gustav

Curtis Blaine

ASKER

Hi Gustav,
I see that you are one of the "Live Consultants". Can I pay you to help with some questions about creating subforms?
If the answer is yes, I would like to know if I can pay through PayPal.

Thanks!

Gustav Brock

Yes I am.

/gustav

Luke Chung

Total Access Analyzer will do what you seek.

It is an Access addin that performs detailed documentation of your Access databases (any format your Access version and permissions let you open).

It documents each object, then performs analysis between objects to generate detailed cross-references and error detection. Over 300 types of errors, suggestions and performance tips are detected. Basically, if Total Access Analyzer detects an error, the database is not ready to ship.

To visually understand what's going on in the database, three diagrams are available: application flow, data flow, and object containership. You're looking for the latter one: http://fmsinc.com/MicrosoftAccess/Documentation/diagrams/index.html

It doesn't show every control (there are too many). It shows the controls that reference other objects.

Hope this helps.