Hyperlink

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello

How can I Using the double-click event on a textbox associated to a hyperlink field, get the a file browser to open allowing the user to select which file that they wish to associate to the current record and then click ok and the hyperlink would be created and save in the appropriate table

Thank you

Daniel
 
Use the File Open/Save API found at:
http://www.mvps.org/access/api/api0001.htm to browse to your document. Then
concatenate a # sign on both sides of the string:

strInputFileName = ahtCommonFileOpenSave( _
Filter:=strFilter, OpenFile:=True, _
DialogTitle:="Please select an input file...", _
Flags:=ahtOFN_HIDEREADONLY)
Me.txtMyTextbox = "#" & strInputFileName & "#"

On my website is a small sample database called "SetHyperlink" which
illustrates this.

--
--Roger Carlson
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org

Daniel P said:
Hello,

How can I Using the double-click event on a textbox associated to a
Click to expand...
hyperlink field, get the a file browser to open allowing the user to select
which file that they wish to associate to the current record and then click
ok and the hyperlink would be created and save in the appropriate table?
 
Back
Top