List fields in all tables in database

[LCalaway]

Evening,
Is there an easy way to list all of the fields in all of the tables in a
database in one report? If so, can some of the attributes be shown as well
(like field type)?
Thank you.
L Calaway

 

[Allen Browne]

Through the interface, you can use the documenter:
Tools | Analyze | Documenter

In code, you can loop through the TablesDefs, and interate the Fields
collection of each one, along with their properties. Example (including
showing the field type as text):
http://members.iinet.net.au/~allenbrowne/func-06.html

 

[LCalaway]

Can you help me further, please. I am REALLY a beginner and am having
difficulty with the code solution offered here.

I created a module and copied the code as given in the link below. I saved
the module to modTableInfo in the database that I want to analyze. (DAO 3.6
is referenced.) I opened the Immediate Window. I am having difficulty in
the substituting the table names in the module. How many places are there
to make the insertion? And, from there I can't seem to guess the correct
step to run the code. I am using Access 2000.

Sorry to be so dumb.
LCalaway

 

[Allen Browne]

Instead of passing in the name of the table you want to examine, do
something like this:

For Each tdf In db.TableDefs
If Not (tdf.Name Like "MSys*" Or tdf.Name Like "MSys*") Then
Debug.Print tdf.Name
For Each fld In ...

End If
Next

 

[Jeff Conrad]

In addition to the Documentor and code solution that Allen mentioned, here is another option.

I created an Access Add-In called the "John Viescas Table Documentor" that does exactly this.
It is even easier to use than the built-in Access Documentor and creates a slick report that will
list
each table (including linked ones) and their field properties in an easy-to-read format. I recently
finished Version 2.0 of the add-in. This version even works on MDE files.

Once installed (takes less than a minute) all you have to do is Tools | Add-Ins | John Viescas Table
Documentor. Poof! After a few seconds a slick report is displayed on the screen. Easy as pie!

I am awaiting word back from John about the possibility of having him post it on his web site where
anyone can download it. In the meantime, I do not believe he would have a problem if I sent you a
copy. If you do wish to have a copy please let me know where you would like it sent to (please mung
the e-mail address so you won't get spammed!). There is one version for Access 97 and one for 2000
which works with Access 2000, 2002, and 2003. I will need to know which version you need.