2
Contributors
2
Replies
5
Views
10 Years
Discussion Span
Last Post by rockygoodness
0

basicly i have a PDF file in the special location, now I want to create a button to open it on MS Access. So if anyone have any idea so pls help ! even open the folder when the PDF is also ok with me! thank

0

basicly i have a PDF file in the special location, now I want to create a button to open it on MS Access. So if anyone have any idea so pls help ! even open the folder when the PDF is also ok with me! thank

Hi, I'm not sure if you or anyone else is still looking for an answer to this. I came across your post trying to find an answer to the same question. I managed to figure a solution out, hopefully it helps. First I created an OLE with my pdf using the unbound object frame tool wizard, followed the directions and browsed my file, then set its visibility property to false in the properties box so you can't see it on my form. Then I created a command button (not using the wizard) and in code builder for my form the button is on used the following:

Private Sub cmdButtonName_Click()

OLEName.Action = acOLEActivate

End Sub

Where "cmdButtonName" is the name of my button, and "OLEName" is the name of my unbound OLE object.

All I have to do to open the pdf is click the command button on the form. Hope this helps!

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.