Hyperlink

[Guest]

In my table I have a field that is a hyperlink. This field is in my frmInput
which information will be inputted by users other than myself. When I access
the form the field is blank. I want to be able to click in the hyperlink
field and have the user browse his drives and select a word file. Is this
possible? or am I asking too much. Thanks.

 

[Scott McDaniel]

In my table I have a field that is a hyperlink. This field is in my frmInput
which information will be inputted by users other than myself. When I access
the form the field is blank. I want to be able to click in the hyperlink
field and have the user browse his drives and select a word file. Is this
possible? or am I asking too much. Thanks.

You can browse for files or folders using either the FileDialog (depending on your version of Access) or by using
Windows API calls. In my opinion, you're better off using the API calls as the code is portable and is not prone to
versioning issues.

Here's code that details how to use the API:
http://www.mvps.org/access/api/api0001.htm

You can run this code on a buttonclick, or in the DoubleClick event of your textbox. Whether it will be a valid
hyperlink after doing this remains to be seen ... you might need to manipulate some of the properties of the Hyperlink
after the API call to insure that the hyperlink works correctly.

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com