I have a hyperlink field on a form that when clicked opens the PDF file that is in the text field.
The PDF file opens for display just fine but doesn't stay on top. The Access form stays on top. Can this be resolved so the PDF stays visible and not behind the Access form?
Here is the onclick code:
Private Sub txtFileName_Click()
On Error GoTo Err_txtFileName_Click
Application.FollowHyperlink Me.txtFileName
Exit_txtFileName_Click:
Exit Sub
Err_txtFileName_Click:
MsgBox "Error Number: " & Err.Number & vbCrLf & "Error Description: " & Err.Description & vbCrLf & "Error Source: " & Err.Source
Resume Exit_txtFileName_Click
End Sub
The PDF file opens for display just fine but doesn't stay on top. The Access form stays on top. Can this be resolved so the PDF stays visible and not behind the Access form?
Here is the onclick code:
Private Sub txtFileName_Click()
On Error GoTo Err_txtFileName_Click
Application.FollowHyperlink Me.txtFileName
Exit_txtFileName_Click:
Exit Sub
Err_txtFileName_Click:
MsgBox "Error Number: " & Err.Number & vbCrLf & "Error Description: " & Err.Description & vbCrLf & "Error Source: " & Err.Source
Resume Exit_txtFileName_Click
End Sub