Printing (or export to file) a list of objects

  • Thread starter Thread starter jjones
  • Start date Start date
J

jjones

I would like to be able to view in either a file or
printed version a list of all the tables and queries and
reports, etc in each database. The only way I have found
to do this so far is to actually bring the browser up on
the screen and then do a print screen, but i would think
access would have some way for me to go ahead and just
export a table list. Any ideas, suggestions??

j
 
Hi,

Here are several options:

1. Go to Tools--Analyze--Documenter (97 version; might be in a different spot for later
versions) and you can print out more information than you care to about everything in your
database.

2. This was recently posted by MVP Doug Steele:
Assuming you have a reference set to DAO, you can use the following:

Sub ListAllForms()

Dim dbsCurrent As Database
Dim docLoop As Document

Set dbsCurrent = CurrentDb()

With dbsCurrent.Containers!Forms
For Each docLoop In .Documents
Debug.Print " " & docLoop.Name
Next docLoop
End With

Set dbsCurrent = Nothing

End Sub

In Access 2000 and higher, it's even easier:

Sub ListAllForms()
Dim frmCurr As AccessObject

For Each frmCurr In Application.CurrentProject.AllForms
Debug.Print frmCurr.Name
Next frmCurr

End Sub

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)

That will list all the forms in your database. You can adapt that for other objects.

3. I have a report that uses a subreport for each of the
objects (tables, queries, etc.). I import this simple
report and 6 subreports into any database and
I instantly have a nice slick print-out of all my database
objects. I use this in all my databases now since it's
great for documentation.

If you'd like a copy just let me know. It's 19KB zipped.

Jeff Conrad
Access Junkie
Bend, Oregon
--Access MVP Matching Game available for download--
 
Back
Top