How to query all the field name of a table in access

T

tracy

I have a bunch of tables in access, and i need to print a report that lists
the field names of those tables without any data. I just want the field names
 
L

Larry Linson

Tools | Analyze | Documenter is the easiest way.

Otherwise, run the Tables collection, and the Fields collection of each
table... you'll need to write them to a Table if you want to print a Report
of the Tables and Fields.

Larry Linson
Microsoft Access MVP

tracy said:
I have a bunch of tables in access, and i need to print a report that lists
the field names of those tables without any data. I just want the field
Click to expand...
names
 
V

Van T. Dinh

Use the Menu Tools / Analyze / Documenter ... and pick only what you want.

--
HTH
Van T. Dinh
MVP (Access)


tracy said:
I have a bunch of tables in access, and i need to print a report that lists
the field names of those tables without any data. I just want the field
Click to expand...
names
 
J

Jeff Conrad

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 right in your
database that you can just open again any time right from the Database Window. It will list each
table and its field properties in an easy-to-read format.You could customize the report even more to
your liking if you desire.

I *believe* John is looking at it right now. I'm hoping he may consider posting it on his web site
where anyone can download it.
 
V

Van T. Dinh

Shouldn't it be called "Jeff Conrad Table Documentor" if you created it?

--
Cheers
Van T. Dinh
MVP (Access)




Jeff Conrad said:
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 right in your
database that you can just open again any time right from the Database Window. It will list each
table and its field properties in an easy-to-read format.You could
Click to expand...
customize the report even more to
 
J

Jeff Conrad

Nope.
It uses code found in John's download files on his web site. He uses this to create a table and
report with all the various table information. A *simple* function call populates the key table with
all the other table information. A report displays all this information. I'm not going to take
credit for his code.

I've been using this for a long time and decided to make an Add-In to do all the work for me. I made
a few cosmetic changes to the report, but overall it is pretty much the same as John's report.

All I have to do now is Tools | Add-Ins | John Viescas Table Documentor. Poof!
After a few seconds a slick report is displayed on the screen. In a nut shell the Add-In creates the
key table, loops through each table (including linked ones) grabbing the information needed, writes
all this information to the key table, creates the report entirely in code, saves it, and then
displays it on the screen for you. That report can be opened again at any time since it is saved as
a new report object in your database. Easy as pie!

The 97 version works with Access 97 and the 2000 version works with Access 2000, 2002, and 2003.
I've tested it extensively on all four versions. Doug Steele sent a copy of each to John for study.
 
F

Fred Boer

That sounds good to me... or maybe "Viescas-Conrad-Boer Table Documenter"..
that has a nice ring to it... yeah....

Oh, wait, I had absolutely nothing to do with it! I guess that wouldn't make
much sense, would it... sigh... ok.. never mind..

Fred Boer (g&r)



as tested by Boer, and seen on TV!
 
Top