Unofficial Access Stuff

Book

Suggestions

Use your pdf converter to make your pdf files easy! You can now buy software that makes converting pdf to doc possible! Did you know you can even convert pdf to word?

Home Page

Bloglines

1906
CelebrateStadium
2006

OfficeZealot

Scobleizer

TechRepublic

AskWoody

SpyJournal

Host your Web site with PureHost!

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.

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

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

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

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

See all Topics

access
Labels: Shortcuts, Tables, Tips

<Doug Klippert@ 3:44 AM

Comments: Post a Comment