Forum home » Delegate support and help forum » Microsoft Access Training and help » Access 2007
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access 2007
Resolved · Low Priority · Version 2007
Reply Tue 15 Nov 2011, 16:29Delegate Kate said...
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?
For upcoming training course dates see: Pricing & availability
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
Reply Mon 21 Nov 2011, 08:45Delegate Kate said...
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
Mon 28 Nov 2011: Automatically marked as resolved.
|