Sarah has attended:
Access Introduction course
Linking Word with Access
Is there a way to link a Word text-box/paragraph with a database cell such that the cell is automatically updated with the updated text in the Word document?
RE: Linking Word with Access
Hi Sarah, Thank you for your post, There is a way but you will need to create an OLE field in your database table.
1. Open the table in design view, and create a new field with OLE properties.
2. Save the design and change to Datasheet view,
3. Select the new empty field and from the menu choose Insert, Object.
4. Select Microsoft Word Document from the options in the middle box, Select Create From File and using the Browse option select your chosen word document file.
5. Click OK and in the dialog box click the Link box, Click OK. The dialog box will close and you will notice in your field the words; Microsoft Word document.
6, If you double click on the field the document will open in Word, and any subsequent changes in the Word document will be reflected each time you double click on the appropriate field.
Note: if you create a Form the Document will be displayed as a graphic, double clicking the field will again open the document with any changes updated.
I hope that helps, best regards Pete.
