G
Guest
For each record in my database I have a hyperlink, if a record doesn't have
an attached hyperlink I would like it to open a specific file. Heres what Ive
tried, bottom half works:
Private Sub ViewWI_Click()
If Me.Work_Instruction.Value = Null Then
Me.ViewWI.HyperlinkAddress = "Y:\AshleyS\Trim Line\Blank Template.doc"
Else
Me.ViewWI.HyperlinkAddress = "Y:\AshleyS\Trim Line\" & _
Me.Work_Station & "\" & Me.Work_Instruction
End If
End Sub
Can u remove the formatting from the hyperlink aswell?? (Blue and underlined)
Thanx in advance
an attached hyperlink I would like it to open a specific file. Heres what Ive
tried, bottom half works:
Private Sub ViewWI_Click()
If Me.Work_Instruction.Value = Null Then
Me.ViewWI.HyperlinkAddress = "Y:\AshleyS\Trim Line\Blank Template.doc"
Else
Me.ViewWI.HyperlinkAddress = "Y:\AshleyS\Trim Line\" & _
Me.Work_Station & "\" & Me.Work_Instruction
End If
End Sub
Can u remove the formatting from the hyperlink aswell?? (Blue and underlined)
Thanx in advance