Kamis, 31 Juli 2014

RE: [MS_AccessPros] Macro to open a PDF in Access 2013

 

Tim

 

Easy-squeezy! Use FollowHyperlink like this:

1.      Open the form in design view

2.      Add a button

3.      Click on the button's click event

4.      Click the little builder button (...) to the right.

5.      Select Code Builder. That will open the code window to the Click event for the button.

6.      Put this line of code in the procedure:

 

Private Sub Command2_Click()

    Application.FollowHyperlink "YourFullPathToThePDFGoesHere"

   

End Sub

 

 

Regards,
Bill Mosca,
Founder, MS_Access_Professionals
That'll do IT http://thatlldoit.com
MS Access MVP
http://mvp.microsoft.com/en-us/mvp/Bill%20Mosca-35852

My Nothing-to-do-with Access blog

http://wrmosca.wordpress.com

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Thursday, July 31, 2014 8:18 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Macro to open a PDF in Access 2013

 

 

Hi,

 

Would any of you please show me now to create a button so that when click, it will open a specific pdf? I can either place the PDF in a folder or attach it into the Access database somehow. I know how to create a button to open a form, but I prefer the PDF because of pictures and images on the PDF.

 

Thanks so much in advance!

 

Tim 

__._,_.___

Posted by: "Bill Mosca" <wrmosca@comcast.net>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (2)

.

__,_._,___

Tidak ada komentar:

Posting Komentar