Use Command buttons to open a hyper link stored in an access database

  • Thread starter Thread starter Jay
  • Start date Start date
J

Jay

I would like to know how to use a commend button in a from
to access a hyperlink stored in a table
 
Hi Jay,

Basically you just use
Application.FollowHyperlink Me.XXX.Value
in the button's Click event Procedure, where XXX is the name of the
control displaying the field containing the URL.

If this is a hyperlink field containing hyperlinks (as against a text
field containing the URL) you may need to use the HyperlinkPart function
to extract the URL from the hyperlink field, something like

Application.FollowHyperlink HyperlinkPart(Me.XXX.Value, acFullAddress)
 
Use the application.followhyperlink function.in your
command buttons onclick ondouble click events....
 
Back
Top