how do I Hyperlink from Access to a folder on a network drive

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi: I have collected lots of emails on a network drive folder. I have also
created a Access database with a hyperlink to the network drive folder where
a email resides.When I click on the hyperlink,I am taken to the network
folder and I choose the email of interest. When I try to set up another
hyperlink in Access to the same network folder I get an error that will not
let me make the hyperlink. It tells me that the location is the same, But I
know that the doccument in the foldsr is different. Is there a work-around
for this? Thank you for time.
 
Try this ...

strFolder = "C:\Development\MyFiles\"
strCMD = "explorer.exe /e, " & strFolder
Shell strCMD, vbNormalFocus
 
Back
Top