Making it easier to create hyperlinks

[qurn]

I have a form that is going to be used for adding records, but it's going to be used by other people, so I'm trying to make it as easy as possible to use. So one of the fields is a hyperlink that should be linked to the file you'd want to veiw, making one of these may be a bit too complicated for my users, so I was wondering if there was a way that if the user where to click on the field it would automatically bring up the edit hyperlink window.

I know to use the on click in the proporties window but don't know where to go from there. Any help would be awesome, Thanks.

 

[Zigzag]

If you use the on click event of the Hyperlink box (or what ever you have called it) you will need to have a way of deciding weather the vba needs to follow the hyperlink currently in the text box or edit add the hyperlink.

You could add another button that could edit/add hyperlink.

The edit/add hyperlink would then open up a windows type explorer where you can then select the path/file to add.

You will need to do a little bit of homework and research the following

BROWSEINFO 'Code courtesy of Terry Kreft
GetOpenFile 'Code courtesy of Ken Getz.

Once done you should have all the knowledge to piece it together.

I have attached a screen shot of the type of thing you can achieve.

Garry

 

[qurn]

Thanks looking at the picture I can tell that this is exactly what I'm looking for, Thanks. I'll be looking at the code but it seems to be a bit needlessly complicated. The good news is that I wount need a button, the form will be used for adding records only, so clicking on the hyperlink box could act like a button. In fact all I'm asking for is a short cut so I don't have to tell my users to right click, go to hyper link, then click on edit hyperlink.