Kate has attended:
Access Advanced course
Access VBA course
Access 2007
Do you now how to print a list of field names and their descriptions, as you might see in design view of a table?
RE: Access 2007
Hi Kate,
Thank you for your question and welcome to the forum.
After looking at a few different sites, some offered long VBA code routines which I think is overkill for what you need.
The first thing would be to print screen the Table Design View and paste into Word. Secondly use the Database Documenter on the Database Tools and select the relevant table.
I hope this helps.
Regards
Simon
RE: Access 2007 table design view
Thanks for this Simon. Is there any way I could download it so that I could edit or manipulate the information in it? I don't think the database documenter includes the descriptions of each field and includes a lot of irrelevant information. Kate
RE: Access 2007 table design view
Hi Kate,
Thank you for your response.
The Description field does appear in the Documenter report but as you quite rightly state there is a lot of data that is not needed.
Unfortunately, without creating some VBA code I cannot think of a way to achieve this in the front end.
Here is a link to some code:
http://www.profinvent.com/index.php/ms-office-automation/ms-office-free-help/43-access-scripts/80-how-to-generate-data-dictionary-in-access
If I do I will email you again.
Regards
Simon
