J
Jim Robinson
How do I print a listing of all the field names, data types, and descriptions
from a table?
from a table?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
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.)
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.)
J
Jim Robinson
Sorry to be a dummy, but once I copy the code, what do I do with it?
A
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.
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.
J
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:
(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: