Print a list of fields with descriptions 2

[vivasuzi]

Hi

Is it possible to print a list of all the fields in the table with the corresponding type and description? It would be nice to just print out the design view but that doesn't seem to be an option.

Let me know what, if anything, I can do!

Thanks,

*Suzanne*

http://www14.brinkster.com/vivasuzi

 

[PHV]

Take a look at the documenter in the Tools -> Analyze menu.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[vivasuzi]

Actually it says that feature is not currently installed, and I don't have the original CD with me. Is there any other way?

And another question, when I print relationships, how can i get it to print every field in a table?

*Suzanne*

http://www14.brinkster.com/vivasuzi

 

[PHV]

You may take a look at the CurrentDB.TableDefs("yourTable").Fields collection.
If you have referenced the ADO Ext library, you may play with the ADOX.Catalog object.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[dhookom]

Look at this solution

http://members.rogers.com/douglas.j.steele/Documentor.html.

Duane
MS Access MVP
[green]Ask a great question, get a great answer.[/green]
[red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
[blue]Ask me about my grandson, get a grand answer.[/blue]

 

[hymn]

have a look at
thread181-542880

tried and tested and the best I've seen

Hope this helps
Hymn

 

[vivasuzi]

This helped a lot! Thanx. I thought I already left a note but I guess I didn't

*Suzanne*

http://www14.brinkster.com/vivasuzi

 

[hymn]

Pleasure thanks for the star

Hope this helps
Hymn