98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » Access 2007
Access 2007
Resolved · Low Priority · Version 2007
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?
Fri 18 Nov 2011, 12:37Trainer Simon said...
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
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
Mon 21 Nov 2011, 13:47Trainer Simon said...
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.
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 tip:Label printingYou can create a report in Access for printing labels All you have to do is is click New under the Reports object and then select Label Wizard and follow the steps |
