98.8% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Access Training and help » access vba courses - Linking Word with Access
access vba courses - Linking Word with Access
Resolved · Low Priority · Version Standard
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.
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:Open A Combo Box AutomaticallyThis is helpful if users need to enter large amounts of data. There are two ways to open ComboBoxes when they get the focus by using the tab keys. |