Hyperlink Default

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jacinda - 22 May 2008 22:21 GMT

Hello, in Access2003...

I have a search form that looks up quotes by quote number etc... one of the
fields on the quote table is a hyperlink to a pdf of the quote form.
Currently I have been linking the pdf files by right-click and find the path
to the file... is there a way to default to a specific drive when I go to
link these.... it would save me a ton of time if it would go directly to the
drive where all of my quotes are stored.

BTW I don't want to set the database default to this drive because I have
other hyperlinks set up in the system... this one is just used more than
others.

Signature

-Jacinda

Reply to this Message

strive4peace - 23 May 2008 00:55 GMT

Hi Jacinda,

rather than using the Hyperlink data type, I store the path\filename as
a text data type and then use

Application.FollowHyperlink me.controlname

on a double-click event to launch it

in your code, if IsNull(me.controlname), you can assume that they want
to choose a file and then present them with a dialog box to pick one.

API: Call the standard Windows File Open/Save dialog box
http://www.mvps.org/access/api/api0001.htm

-- and you can specify a start directory

you can also have a command button to browse to a file in case they want
to change what is already filled in

Warm Regards,
Crystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
(: have an awesome day :)
*

> Hello, in Access2003...
>
[quoted text clipped - 8 lines]
> other hyperlinks set up in the system... this one is just used more than
> others.

Reply to this Message