How do I print a list of all the field names showing in a table d.

  • Thread starter Printing Field Name List
  • Start date
P

Printing Field Name List

I'm new to Access. I'm working with a database that has about 40-50 fields
(I guess that's what they're called). In the table desgn view the field
names are listed. How do I print this list?
 
S

Sprinks

Access comes with a Documenter feature that can print an enormous amount of
detail on your application's objects.

To print a list of just your table's field names, field types and sizes,
choose Tools, Analyze, Documenter from the Database window menu. Select the
table of interest from the Tables tab, click on the Options button, deselect
the Table options, choose Nothing for the Indexes options, and choose the
Names, Datatypes, and Sizes option for the fields. Click OK twice to preview
the report.

Hope that helps.
Sprinks
 
J

Jeff Conrad

Try Tools | Add-Ins | John Viescas Table Documentor.
That will print out just what you need.

You do not have that 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.
 
J

Jeff Conrad

Hi Ted,

'Mung" the e-mail address means make it so a human
can decipher the address, but not a machine. SPAM
harvesters can use programs to collect e-mail addresses
from public newsgroups. If you were to post your
actual e-mail address just as it would look in normal view,
you would undoubtedly begin to see a flood of SPAM!

Since I have not received word back from John yet on
the possibility of him posting this add-in on his web site,
I have to send it through e-mail to people that would like
a copy. I certainly do not want, however, to see people
get flooded with SPAM so I ask that people mung their
e-mail address.

I can certainly send along a copy for you. Do you need
the 97 version or the 2000 version? The 2000 version
works with Access 2000, 2002, and 2003.

Let me know where you would like it sent by doing
something like so:
ted
at
somewhere
dot
com

A machine would have difficulty seeing the above as
an e-mail address.
 
Top