Tool for documenting forms etc?

[WaltW]

Is there a simple tool for documenting what tables & queries are used by forms, sub-forms, reports, etc - without having to go through the forms one by one? In particular it would be nice to easily identify all the forms, reports, etc in which a particular query/table is used. Thanks for any help offered!

Walt

 

[FastLearnerIThink]

You can right click on any object and select object dependencies. Not sure if this is what you were looking for, but maybe it helps.

-- Fast Learner, I Think

Here's something to think about. How come you never see a headline like 'Psychic Wins Lottery!'? - Jay Leno

 

[Remou]

This may help:
Find All Databases that use a Table
thread700-1140015
How to find which form/objects are linked to a table?
thread700-925308
I think there are lots more. I did not try very hard.

 

[PHV]

Have a look here:

http://www.jrbarnett.freeserve.co.uk/mdbdoc.htm

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[WaltW]

Thanks much to all who responded. The MDBDOC add-in looks especially interesting!

-Walt