R Rpettis31 May 2, 2008 #1 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.
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.
D Daniel Pineault May 2, 2008 #2 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.
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.
