List of All Objects With Dependencies

[Guest]

Is there any way to generate a list of all objects with their dependencies?
In particular, I am trying to get a list of reports/queries with their
subreports and subqueries. I am creating a list of reports for my users to
select from, and it would help me narrow it down if I could figure out easily
what the top-level ones were. I can look at the dependencies for an
individual object on the screen, but I can't see any way to look at multiple
objects or to print the information. Ideas, anyone?

 

[Guest]

Click on menu TOOLS - Analyze - Documentor.
Click on Reports. Select your options and run. Save to Word by clicking on
the W icon on the tool bar.
Search in Word.

 

[Guest]

Which options should I select? I haven't seen any marked "Dependencies", and
"Properties" doesn't seem to help.

 

[John Vinson]

Is there any way to generate a list of all objects with their dependencies?
In particular, I am trying to get a list of reports/queries with their
subreports and subqueries. I am creating a list of reports for my users to
select from, and it would help me narrow it down if I could figure out easily
what the top-level ones were. I can look at the dependencies for an
individual object on the screen, but I can't see any way to look at multiple
objects or to print the information. Ideas, anyone?

There are some good third-party tools to do this - Total Access
Analyzer probably is what you'll need to get the full benefit (it's
worth the nontrivial price in my opinion).

Find and Replace: http://www.rickworld.com
Speed Ferret: http://www.moshannon.com
Total Access Analyzer: http://www.fmsinc.com

John W. Vinson[MVP]

 

[Guest]

Is there anything within Access itself? This is for my work computer, and in
order to buy anything, I have to go through my boss, IT, and Accounting, and
by that time I'll have given up and done it all longhand
--
Amy E. Baggott

"I''m going crazy and I''m taking all of you with me!" -- Linda Grayson

 

[John Vinson]

Is there anything within Access itself? This is for my work computer, and in
order to buy anything, I have to go through my boss, IT, and Accounting, and
by that time I'll have given up and done it all longhand

<wry grin> I'm afraid not, at least not that I've found.

You can find references in VBA code - using the binoculars/Search
option and selecting "Entire Project" - but AFAIK there's no easy way
to find which forms are linked to other forms, or which queries
reference one another, without writing quite a bit of VBA code.

John W. Vinson[MVP]