Hyperlink command button

[Rpettis31]

I am trying to add a command button to go to a link. If there is not link a
hyperlink value a box will pop up to insert the hyperlink.

 

[Daniel Pineault]

If it is set as a hyperlink and not just text, then the user need only click
on the hyperlink to open the file.

Otherwise you could simply use the FollowHyperlink method.

Application.FollowHyperlink "FullPath\FileName"


So you could do something like

If Me.ControlName="" Then
'Call File Dialog
Else
Application.FollowHyperlink "FullPath\FileName"
End if

For the file dialog code take a look at
http://www.mvps.org/access/api/api0001.htm
--
Hope this helps,

Daniel Pineault
For Access Tips and Examples: http://www.cardaconsultants.com/en/msaccess.php
If this post was helpful, please rate it by using the vote buttons.