Access Field Name List

[Guest]

How do I print a listing of all the field names, data types, and descriptions
from a table?

 

[Allen Browne]

See the code at:
http://allenbrowne.com/func-06.html

The article shows how to list the Fields of the TableDef, showing the data
types (by name) and sizes, and the Description field (if they have one.)

 

[Guest]

Sorry to be a dummy, but once I copy the code, what do I do with it?

 

[Allen Browne]

Select the Modules tab of the Database window.
Click New. Access opens a module.
Paste the code in.
Save with a name such as Module1.
Check that Access understands it by choosing Compile on the Debug menu.

If Access 2000 or 2002 gives an error message about unknown types, choose
References on the Tools menu, and check the box beside:
Microsoft DAO 3.6.

One it compiles okay, press Ctrl+G to open the Immediate window.
Then enter:
? TableInfo("Table1")
substituting the name of your table for Table1.

There is also a built-in way to document the table:
Tools | Analyze | Documenter
It's more difficult to get just the stuff you asked for though.

 

[Jeff Conrad]

In addition to Allen's suggestions, here are several more.
(Allen's is also in the list as well)

http://home.bendbroadband.com/conradsystems/accessjunkie/doctable.html

(Watch out for any possible line wrapping on that link)

--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
http://www.access.qbuilt.com/html/articles.html

in message: