How to Print a List of Tables or Forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Using Access 2003, is there a way to print the list of tables, reports, or
forms? For example, I only want to print the list of tables in my Access
database, not the contents of each table.

Any suggestions? I appreciate it.

Thanks.

Kenny
 
Thanks Rick for the quick response. Documenter list each table on a separate
print out. I was hoping for more like a single page listing of all the tables
in a database.

table 1
table 2
table 3

Is this possible?
 
Using Access 2003, is there a way to print the list of tables, reports, or
forms? For example, I only want to print the list of tables in my Access
database, not the contents of each table.

Any suggestions? I appreciate it.

Thanks.

Kenny
Click to expand...

If all you wish is a list of the tables, forms, and reports, without
any more information included, then you can write a query:

SELECT IIf([Type]=1,"Table",IIf([Type]=-32768,"Form","Report")) AS
ObjectType, MSysObjects.Name
FROM MSysObjects
WHERE (((MSysObjects.Type)=1) AND ((Left([Name],4))<>"MSys")) OR
(((MSysObjects.Type)=-32768)) OR (((MSysObjects.Type)=-32764) AND
((Left([Name],1))<>"~"))
ORDER BY IIf([Type]=1,"Table",IIf([Type]=-32768,"Form","Report")),
MSysObjects.Name;


If you need additional information included, use
Tools + Analyze + Documenter
 
"Kenny" wrote in message:
Thanks Rick for the quick response. Documenter list each table on a separate
print out. I was hoping for more like a single page listing of all the tables
in a database.

table 1
table 2
table 3

Is this possible?
Click to expand...

One of my add-ins will do something similar. It will list the name of
each object alphabetically 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://www.accessmvp.com/djsteele/Documentor.html

Hope you like it!
 
Back
Top