Start windows explorer from access hyperlink field

[Andreas]

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 ?

 

[Allen Browne]

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.