How can I print all the field names & data types from a table

M

M.Siler

I'd like to print the field names, data type and field size for a table. If
possible for all the tables in an mdb. I'm using Access 2002 SP3.
 
M

Mike Labosh

I'd like to print the field names, data type and field size for a table.
If
possible for all the tables in an mdb. I'm using Access 2002 SP3.
Click to expand...

Tools -> Analyze -> Documenter

That launches a wizard the helps you do that with lots of flexible options.
--
Peace & happy computing,

Mike Labosh, MCSD

"It's 4:30 am. Do you know where your stack pointer is?"
 
M

Mike Labosh

Thank you... I assume the wizard is with version 2003?

It's in there somewhere. The most important thing that Microsoft does in
every version is rearrange all the menus so we can't find features we
already know how to use. :^)
--
Peace & happy computing,

Mike Labosh, MCSD

"It's 4:30 am. Do you know where your stack pointer is?"
 
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.

Once installed 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. In a nut shell the Add-In creates a new key
table in your database, 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!

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 2000, 2002, and 2003.
 
D

Douglas J. Steele

It is, in exactly the same place Mike wrote for Access 2002 (for a change!)
 
J

Jeff Conrad

M.Siler said:
Please email it to.....
Click to expand...

Hi,

You did not mention which version you needed so I sent both to the e-mail address you provided. Only
install the 97 one if you are using Access 97. If you are using Access 2000, 2002, or 2003 then
install the 2000 one (You mentioned 2002 before so I assume that is what you have). Follow these
steps to install the Add-In:

1. Unzip the file JVTableList.MDA to your Office or Access directory to easily find it when we
install the Add-In.

2. Now open any Access database and go up to "Tools" on the main Access menu bar. From there go down
to the option called "Add-Ins". This sub-menu will list any installed Access add-ins on your system,
as well as an option called "Add-In Manager". Click on the option called "Add-In Manager" and a new
screen will appear.

3. The box will display a list of available add-ins on the left side. Depending upon where you
unzipped the add-in file, you may see the John Viescas Table Documentor already listed in this box.
If the file is listed, click on the option to highlight it and then press the "Install" button to
complete the installation. There should now be a little "x" next to the option meaning it has now
been installed. If you do not see the add-in listed in this box simply click the button called "Add
New..." where you can browse for the location of the file. Once you find the file and click on it in
the browse window, you will be taken back to the Add-In Manager screen. Now you should see our
add-in listed in the box with a "x" by it meaning it has been successfully installed. If not,
highlight the option and then press the "Install" button to complete the installation. Hit the
"Close" button on the Add-In Manager when finished. That's it, now we're ready to use the utility!

4. To launch the add-in, simply open any database you wish to document and go up to Tools | Add-Ins
and click on the new option "John Viescas Table Documentor". Depending upon the number of tables in
your database (and whether they are linked or not), the utility should only take a few seconds to
create the report and display it on the screen. Once on screen you can either print the report or
just view the different pages. The utility creates a new report object in your database called
"rptzvTableFields" and a new table called "zvTableFields". If you wish to view the report again, you
can simply open the report in the Database Window or re-run the add-in utility if you have
added/changed/deleted new fields and/or tables. You can delete these database objects if you do not
wish to have them in your database.

Please post back to the newsgroup when you receive the files and if have any problems . The e-mail
was being sent from a "dump" e-mail account and will not be checked if a reply is sent. The only way
I will know if you received the files is through the newsgroup.

Hope you find it useful.
 
J

Jeff Conrad

Hummm that's strange.
I'll try again right now.
It could be something on my end so post back again when you receive it or if you don't get the file.
If it does not arrive I'll try Plan B.
 
J

Jeff Conrad

Sorry about the trouble.
I definitely think the problem was on my end.
Our satellite modem connection was intermittent which may have messed up the transmission.
A quick brush off of the snow seems to have cleared it up.
*Hopefully* you should get it now. Let me know.
 
Top