Access 2003 to Word

Resolved · Urgent Priority · Version 2003

Fri 17 Jul 2009, 22:21 Delegate Dania said...

Dania has attended:
Access Introduction course
Access Intermediate course

Access 2003 to Word

Hello,

I have created a form in Access that I would like to send via email. Is there anyway of converting the file into .doc.or pdf (the recipient only needs to view the file)????

Thank you,
Dania

Mon 20 Jul 2009, 09:28 Trainer Stephen said...

RE: Access 2003 to Word

Hi Dania

Thank You for your question

It is actually quiet simple to publish for form in Microsoft Word. You can then email it as an attachment

Open you database and go to the forms view in the database window. Select the form that you want to send

In the middle of the Access tool bar you will see a button with either a Microsoft Excel or Word icon on it. Select the arrow along side it and from the resulting menu choose, "Publish it with Microsoft Word". This will the create a word document showing the data in the form.

Hope this helps

Regards

Stephen

Mon 20 Jul 2009, 12:08 Delegate Dania said...

RE: Access 2003 to Word

It worked!

Thanks Stephen.

Best wishes,
Dania

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

Create a custom Close button on a Form

By default, Forms that you create in Access have a full set of control buttons, that is, a title bar with Minimize, Maximize and Close buttons in the top right-hand corner and a Control Menu in the top left-hand corner.

Sometimes Access needs to follow certain procedures or events as users close a Form (such as automatically opening another Form perhaps). So it is often a good habit to create a custom Close button on a Form for everyone to use, rather than the standard closing cross.

To create a custom Close button:

1) In Form Design View, draw a Command Button onto the Form.

2) Use the Command Button Wizard to select Form Operations under Categories, and Close Form under Actions.

3) Choose Finish.

Access then creates the button and code to close the form for you. You can add any extra code that needs to run as the Form closes to the same Close procedure.

However, the creation of a custom Close button is pointless if the closing X in the top right-hand corner of the Form remains active. To make the closing X inactive, open the Form Properties box then on the Format tab set the Close Button setting to No. This will grey out the closing X leaving it visible, but inactive.