Hyperlink help

  • Thread starter Thread starter Andy Bowring
  • Start date Start date
A

Andy Bowring

Hi

I know that this is going to be easy for someone out
there. I have a folder on my C: drive which contains sub
folders which appertain to each record in my database.
The sub folders contain word documents and photos
relating to each record. How do I create a hyperlink to
each sub folder which is unique to each record in the
database. Hope that makes sense.
 
Andy Bowring said:
I know that this is going to be easy for someone out
there. I have a folder on my C: drive which contains sub
folders which appertain to each record in my database.
The sub folders contain word documents and photos
relating to each record. How do I create a hyperlink to
each sub folder which is unique to each record in the
database. Hope that makes sense.
Click to expand...

Hyperlinks are links to files, not folders. You may want to open the folder
by browseing for it:

http://www.mvps.org/access/api/api0002.htm
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Arvin Meyer said:
Hyperlinks are links to files, not folders. You may want to open the
folder by browseing for it:

http://www.mvps.org/access/api/api0002.htm
Click to expand...

FWIW, though, you *can* follow a hyperlink to a folder. For example,

Dim strFolder As String

strFolder = "C:\Temp"

Application.FollowHyperlink strFolder

will open that folder in Explorer; at least, it does on my system. Or
one can shell to Explorer to open the folder:

Shell "Explorer.exe " & Chr(34) & strFolder & Chr(34), vbNormalFocus

A question for Andy, not for Arvin:

Do you really want to store the folder as a hyperlink? I find it
much easier to just store file and folder names as text field, and use
my own code, as in the examples above, to open them when the user
requests it by some action.
 
Back
Top