Design view information - exporting field names, data types & desc

[NatP]

Hi there,

I have just started using Access 2007 and have noticed that you can no
longer select/copy/paste the design view table information into a word
document (i.e. fieldname, data type and description, NOT the table records
data).

I am using the database to store clinical trial information and need to do
the above so that I can supply a data dictionary to the study statistician.

Is there a way I can do this without so that I have the information in a new
table in Word that I can add/change/delete? A screen shot will definitely
not do.

Thanks so much,
Natalie.

 

[Allen Browne]

Here's some code that prints the field names, data types and descriptions
into the Immediate Window:
http://allenbrowne.com/func-06.html

You could then copy'n'paste from there to Word. Or, adapt the code to do
what you want.