| |
banker
Posts: 1
Score: 0
Joined: 5/24/2001
From: USA
Status: offline
|
With Access 97 I have been trying to open Acrobat in C: and point to a document in another folder as a event procedure on a form. The problem arises when I try to select the document from the folder based on the field. I tried something like this:
Private SubForm_Load()
strFileRoot = "C:\My Documents
"End Sub
then adding a button like this:
Private Sub Command6_click()
On Error GoTo Err_Command6_Click
FollowHyperlink strFileRoot & Me.Mypdf & ".pdf"
Exit_Command6_Click:
Exit Sub
Err_Command6_ Click:
MsgBoxErr.Description
Resume Exit_Command6_Click
End Sub
Woefully, I cannot select varied .pdfs. I can open ONE but when I try to make that selection based on the info in a field, I get messages that the event procedure is incorrect. I am NOT fluent in VBA.
Please help. I have tried Macros also with the same results. Only sucess with an individual doc, not multiple ones.
|
|
Printable Version
RunApp from module & point to varied documents - 
New Messages
No New Messages
Hot Topic w/ New Messages
Hot Topic w/o New Messages
Locked w/ New Messages
Locked w/o New Messages
Post New Thread