Trouble with FollowHyperlink

[lawdy]

On a form, I have 2 buttons:


Private Sub btnHyperLink_1_Click()
FollowHyperlink "L:/20231470.pdf"
End Sub
and
Private Sub btnHyperLink_2_Click()
FollowHyperlink "L:/aaTS/AFilesToCopy/Job Plans/2023/20231470.pdf"
End Sub


btnHyperLink_1 works real good but btnHyperLink_2 don't work at all. The file IS located at both locations. Is there a limit on how deep one can go in the file system or am I doing it wrong?

[Micron]

AFAIK there is a limit but it is over 1,000 characters. Can only think that your issue must be that the 2nd path is not correct, even if by only one character or space. Try navigating to the file in File Explorer and copy/paste the path (and add file name to it) in your code.

[Welshgasman]

Suprised that even worked as I would use \ as it is Windows and not Linux/Unix?

However it appears to do so.
What error message are you getting?

[lawdy]

Ok, you hit it. I had left out 1 character in the string. I also changed the '/' to '\'. Thanks to both of you for solving my problem.

[Micron]

It works either way for me. In fact, it works with a mix of / and \. However, using / raises a security warning dialog. Methinks Shell might be a more reliable way of doing this.

http://access.mvps.org/access/api/api0018.htm

[Welshgasman]

It works either way for me. In fact, it works with a mix of / and \. However, using / raises a security warning dialog. Methinks Shell might be a more reliable way of doing this.

http://access.mvps.org/access/api/api0018.htm

Yes, even with Dir
? dir("f:/temp/Music List.pdf")
Music List.pdf


However I will stick with \ for Windows and / for Linux and not confuse myself.