mnemosyne
Last Activity: Dec 31 '15, 05:01 PM
Joined: Oct 10 '06
Location:
-
i just found this 9 years later after trying to remember how i did this 9 years ago...... -
ok i'll answer my own post for s&gigs
in case some googlers come round asking the same question...
I right clicked the text i wanted to use as a hyperlink, clicked Build Event... then Code Builder
then i entered this VBA code:
...Code:Private Sub Link_Label_Click() Dim strfile As String strfile = Me.controlname + ".doc" Application.FollowHyperlink strfile End Sub
Leave a comment:
-
Dynamic hyperlink in form
hi i'm trying to figure out how to have a hypertext link in a form use the information entered from a separate field in order to link to a word document
EXAMPLE
Link to Report is a hyperlink that gets the Medical Record # from another field and uses that to link to "[Medical Record #].doc" so that when a patient's Medical Record # is entered as 0001, the hyperlink will open "0001.doc" and so forth
...
No activity results to display
Leave a comment: