I have a hyperlink field and the user has to right-click and select Edit Hyperlink then browse to the file to insert a link. Could someone tell me the code to use if I want to have a Double-Click Event to Edit Hyperlink. Also is there a way to specify a folder to automatically browse to?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Code to Edit Hyperlink
- Thread starter tbac
- Start date
TheAceMan1
Programmer
How are ya tbac . . .
You can use the API [blue]GetFilenameFromBrowse[/blue] (see my post here: thread702-1289131) to set the dir and extension to browse, using its return value to determine wether to update the hyperlink field. The double-click event would look something like:
The above assumes your not using any hyperlink text for display.
[blue]Your Thoughts? . . .[/blue]
See Ya! . . . . . .
Be sure to see thread181-473997 [blue]Worthy Reading![/blue]![[thumbsup2]](/data/assets/smilies/thumbsup2.gif "[thumbsup2] [thumbsup2]")
Also faq181-2886 [blue]Worthy Reading![/blue]
You can use the API [blue]GetFilenameFromBrowse[/blue] (see my post here: thread702-1289131) to set the dir and extension to browse, using its return value to determine wether to update the hyperlink field. The double-click event would look something like:
Code:
[blue] Dim Fil As String
Fil = BrowseFiles() 'Get FileName from preset Dir!
If Fil <> "" Then Me![purple][B][I]HyperLinkFieldName[/I][/B][/purple] = "#" & Fil & "#"[/blue][blue]Your Thoughts? . . .[/blue]
Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]
- Status
Similar threads
