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

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

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

John

Steve laid this down on his screen :
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

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" wrote in message
...
Run the Documenter.
Go To Tools, Office Links, and select Publish It With Microsoft Word.

John

Steve laid this down on his screen :
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

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 :
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" wrote in message
...
Run the Documenter.
Go To Tools, Office Links, and select Publish It With Microsoft Word.

John

Steve laid this down on his screen :
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

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.

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" wrote in message
m...
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" wrote in message
...
Run the Documenter.
Go To Tools, Office Links, and select Publish It With Microsoft Word.

John

Steve laid this down on his screen :
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, Fred! Worked great.

Steve


"Fred" wrote in message
...
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.