OK, I got this hyperlink field to open with Adobe Acrobat as below, but I would also like it to hide the query's datasheet view of the hyperlink. I do not know how to set a query's visible property in VBA though.
Code:
Private Sub Command59_Click()
Dim qryLithLogLinks As Hyperlink
DoCmd.OpenQuery ("qryLithLogLinks")
DoCmd.RunCommand acCmdOpenHyperlink
End Sub
Code:
Private Sub Command59_Click()
Dim qryLithLogLinks As Hyperlink
DoCmd.OpenQuery ("qryLithLogLinks")
DoCmd.RunCommand acCmdOpenHyperlink
End Sub