Bookmark and Share

Enter your email address:

Delivered by FeedBurner



Home Page













Subscribe here
Add to My Yahoo!
This page is powered by Blogger. Isn't yours?

Host your Web site with PureHost!


eXTReMe Tracker
  Web http://www.klippert.com



  Friday, November 13, 2009 – Permalink –

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.


[Edited entry from 11/7/2006]


See all Topics

Labels:


<Doug Klippert@ 3:40 AM

Comments: Post a Comment

Links to this post:

Create a Link