Start windows explorer from access hyperlink field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Andreas - 18 Dec 2004 07:53 GMT

I have a table in access where one of the fields is a hyperlink field. In
this field I have included various filepaths exluding the filename (ie.
various folders). The thought was that when the user clicks on this
hyperlink, that should launch windows explorer which would open with the path
in the hyperlink. However nothing happens when the hyperlink is clicked. Is
there a way to do this ?

Reply to this Message

Allen Browne - 18 Dec 2004 10:39 GMT

Check that the Address part of the hyperlink field (the middle part) is
correct.

If it contains a folder name, the hyperlink should fire the Windows Explorer
unless some other shell is installed or folders are designated to something
else.

HyperlinkPart() might help you parse the address part.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>I have a table in access where one of the fields is a hyperlink field. In
> this field I have included various filepaths exluding the filename (ie.
[quoted text clipped - 4 lines]
> Is
> there a way to do this ?

Reply to this Message