Now I've set up a Hyperlink field in my table and can't work out what sort of control I should place on the user form.
The hyperlink field is going to receive the full path & name of a Word document, the document being the source of my data.
My theory is that I'll load my data fields from text in the document, but maintain a link to the original source so that I can quickly fire up Word and see the original press release.
Of course, I could just use a text box and write the VBA code to execute the file - whatever it is - instead of firing up a web browser.
Here is my web page textbox code:
Code: Select all
Private Sub WEBPAGE_Click()
If Len(Trim(Me!WEBPAGE)) > 0 Then
Call KillBrowserJob
Dim retval As Double
Dim strDestination As String
strDestination = Me!WEBPAGE
retval = Shell("C:\Program Files\Mozilla Firefox\firefox.exe " & strDestination)
Else
End If
End Sub