Printing list of forms and tables

  • Thread starter Thread starter Deb
  • Start date Start date
D

Deb

Hi all..

Is there a way that I can print a list of all the forms
and tables and reports that I have in my database. I
dont want the information in them, just a list of them.

---Deb
 
iN THE VISUAL BASIC MODULE SEARCH HELP FOR "TABLES COLECTION"

SAMPLE CODE IS GIVEN (FOR DAO)THIS WILL OUTPUT TO YOUR IMMEDEATE WINDOW
COPY THE ANSWER TO A TEXT DOCUMENT

EXTEND YOUR SEARCH TO REPORTS AND FORMS

YOU CANDO THE SIMILAR WITH ADO THE CURRENT TECHNOLOGY AND THE CODFE WILL BE
IN THE SAME LISTINGS IN HELP
 
Is there a way that I can print a list of all the forms
and tables and reports that I have in my database. I
dont want the information in them, just a list of them.
Click to expand...

Hi Deb,

You can use the built-in Access Documentor
(Tools | Analyze | Documentor) to get a huge list of just about everything
you ever wanted to know about the database. At the same time, you can
keep the logging and paper manufacturing industry going strong in Oregon!
Depending upon the options you select, you could fell several trees.
:-)

Personally, I would suggest you try my "Doug Steele Object Documentor"
Add-In for Access. This add-in will create a nice report of all your database
objects for easy reference. The report will list all the objects by category in
alphabetical order in a three-column layout. It looks very sweet in my opinion
and it's even easier to use than the Access Documentor. Plus, you get a nice
report saved in your database that you can open again any time you wish!
There is one version for Access 97 and another version that works for
2000, 2002, and 2003.

After installing, which takes all of about a minute to do, you simply do:
Tools | Add-Ins | Doug Steele Object Documentor
That's it! Poof! A nice slick report created in your database in just a
couple of seconds. And best of all, you can use it on any MDB file.

You can find the free Add-In on MVP Doug Steele's site here:

http://members.rogers.com/douglas.j.steele/Documentor.html

Hope you like it!
 
Back
Top