How to create Hyperlink Macro

[ppons]

I use Access 2007. I made a form to add/edit the Hyperlink of a file on a
shared drive. I am having a difficulty in creating a macro to open the edit
hyperlink window, with the default location, and then the user clicks on
browse for file to go and select his/her file. Can anyone help me.

 

[Steve Schapel]

Ppons,

No, this can't be done with a macro. You will need to use VBA. As a
starting point, have a look at:
http://www.mvps.org/access/api/api0001.htm