Hyperlink in ACCESS do show all files seen in Windows explorer

[Guest]

I am making a data base of certain corrospondance and using the hyperlink in
MS Access to collate the corrospondance.
Most of the time I can select the file from the "Insert hyperlink" drop
down window, but on several occasions, I can see the file in Windows Explorer
and it will open from there, but I cannot see it in the "Inser hyperlink"
window, nor in the "Link to File" window.

 

[Allen Browne]

FollowHyperlink gives you the Windows Explorer if you specify a folder,
e.g.:
FollowHyperlink "C:\MyFolder"

Alternatively, you can explicitly shell the explorer, and use its command
line switches, e.g.:
Shell environ("windir") & "\explorer.exe /e, /select, ""c:\MyFolder\""",
vbNormalFocus

 

[Guest]

Hello Allen,
Thank you for info, but it is a little too cryptic. Where do you type the
FollowHyperlink details?
Engine

 

[Douglas J. Steele]

You type it in whatever code you've got that you want to launch Windows
Explorer. For example, if you want it to launch when the user clicks on a
button, you put the code in the Event Procedure for that command button's
Click event:

Private Sub MyButton_Click()

FollowHyperlink "C:\MyFolder"

End Sub