Access 2007

Resolved · Low Priority · Version 2007

Tue 15 Nov 2011, 16:29 Delegate 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:37 Trainer 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:45 Delegate 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:47 Trainer 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 courses

	98.8 % recommend us
	More live stats...

Training information:

Access tip:

Label printing

You 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

View all Access hints and tips