Viewing only the type & size of the fields

[Nathan Sokalski]

I want to print an outline of the type and size of each field in my DB
tables. When I go to Tools->Analyze->Documenter->Tables it shows me tons of
other information as well, which will obviously make the printout very long
and when using it as a reference to determine the maximum input for a field
(I am a web developer, and like to have a reference of the DB I am using),
it can be annoying to need to look through many pages to find this info. Is
there any way that I can make a simple outline of the type & size of each
field? Thanks.

 

[Duane Hookom]

You can create your own reports based on the results of the documenter.
There are some instructions here http://www.access.hookom.net/Documenter/.

 

[John Vinson]

Is there any way that I can make a simple outline of the type & size of each
field?

Yes; open the Documenter, and click the Options button at the lower
right of the window. Uncheck the things that you don't want to see.

John W. Vinson[MVP]

 

[Fred Boer]

You might want to look at the following:

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

HTH
Fred Boer

 

[Nathan Sokalski]

Thanks! That worked great, but there is one thing about the results that I
want to ask. It seems to want to put all the tables on different pages, but
they will all definitely fit on the same page. Is there some way I can
change this? Thanks.

 

[Albert D.Kallal]

You can get a nice columnar listing from the documenter.

You just need to click on the options buttons. If you "un-check" most of the
options, then you get a nice columnar listing.

 

[Duane Hookom]

I don't believe there is a method to change the report setup in this add-in.
Your only alternative may be to use one of the other documentation methods.

 

[Jeff Conrad]

in message:

Thanks! That worked great, but there is one thing about the results that I want to ask. It seems
to want to put all the tables on different pages, but they will all definitely fit on the same
page. Is there some way I can change this? Thanks.

That is one of the *main* reasons I made my own add-in for this.
I've never found the Documenter to be paper-friendly.

 

[Albert D.Kallal]

Click on the button to send the document to word, and edit it?