Is there a way to get a list of the fields in a table into Word

[Steve]

How can I get a list of the fields in an Access table into Word? I am
working on a very misdesigned database where one table has over 100 fields
and several others have over 50 fields. I am writing a report in Word and
want to include the list of fields in certain tables. I am aware of the
documenter; is there a way to get a documenter report into Word?

Thanks!

Steve

 

[JvC]

Run the Documenter.
Go To Tools, Office Links, and select Publish It With Microsoft Word.

John

Steve laid this down on his screen :

 

[Steve]

John,

Thanks for the quick response! The documenter gives me field name, suze and
type so I get three columns in Word. I could clean it up so I only have the
field name but that would be a bit tedious. Any idea how to just get the
field names?

Thanks!

Steve

 

[JvC]

Go to Options in the documenter, and select only Field Names, Data
Types and Sizes. That's about the minimum.

Steve has brought this to us :

 

[Fred]

You could do some fast cleanup in Word using global deletes to remove spaces,
tabs, repetitive used field type words (e.g. "text") and repetitively used
(e.g. default) max field size numbers.

 

[Paul Shapiro]

You could write your own code to loop through the db's tabledefs, and for
each table loop through the fields. Something like:

For each tdf in dbcurrent().tableDefs
debug.print tdf.name
strOutput = strOutput & vbCrLf & tdf.name
For each fld in tdb.fields
debug.print fld.name
strOutput = strOutput & vbCrLf & vbTab & tdf.name
Next fld
Next tdf
'Write strOutput to a text file.

I've written code to do formatted output directly into Word, but if all you
want is the table and field names, you could write it out to a text file.

 

[Steve]

Thanks, Fred! Worked great.

Steve