Tuesday, July 19, 2016

Link to Office Documents from Access

Click to Word, PowerPoint, Excel


You can create hyperlinks in Access that jump to other Office documents. The process of specifying the document and the bookmark you want to jump to can be cumbersome.

There's an easy way to specify where in a Word, Excel or PowerPoint document that a hyperlink should jump to, without even having to open the Insert Hyperlink dialog box.

  1. Open the target document and the Access table that contains a hyperlink field.

  2. Select some of the text at the beginning where you want the hyperlink to jump.

  3. Hold down the Ctrl key, drag the selection to the Access hyperlink field you want to set up.

  4. When you release the mouse button, the previously selected text is used as the hyperlink text and the link becomes active.




See all Topics

No comments: