Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 05-21-2014, 05:47 AM   #1
MattAnderson
Newly Registered User
 
Join Date: Mar 2014
Posts: 11
Thanks: 2
Thanked 0 Times in 0 Posts
MattAnderson is on a distinguished road
Unhappy Print PDF from Access form

Hey guys I'm wondering if you can help me with the issue I'm having at the moment.

What I want to achieve is to have a button in a form that can print a PDF that is in my documents.

This PDF is not related to the database in anyway shape or form. I know you can open a PDF from a form by using a hyperlink but I would like to automate this process a bit more but making it automatically print the pdf and then close down Adobe Reader.

I'm not sure whether or not this possible or not but if anyone could advise me that would be great.

Thanks in advance,

Matt

MattAnderson is offline   Reply With Quote
Old 05-21-2014, 06:19 AM   #2
micks55
Newly Registered User
 
Join Date: Mar 2006
Location: Cambridge UK
Posts: 96
Thanks: 7
Thanked 4 Times in 4 Posts
micks55 is on a distinguished road
Re: Print PDF from Access form

Just an option that might suit.
In my work, we need to look at .doc .pdf and .xls files so I use the MS WebControl. It's in my Access 2k tools so I guess something is around in later versions also. You'll need to store the full path in a table and call it into the WebCtrl with...
Me!WebCtrl.Object.Navigate List41 '(List41 is the listbox based on the file paths table)
This way they are viewable and Word/Excel files can be edited because we have MS Office. And this all happens directly in the webcontrol "window" on my form.

I've not tried printing from there as we don't want paper when we can view and zoom them so easily but I doubt it would be difficult.
Good Luck and pls don't think it rude if I'm not around very often.
micks55 is offline   Reply With Quote
Old 05-22-2014, 05:32 AM   #3
MattAnderson
Newly Registered User
 
Join Date: Mar 2014
Posts: 11
Thanks: 2
Thanked 0 Times in 0 Posts
MattAnderson is on a distinguished road
Re: Print PDF from Access form

Thank you very much for you help. I have come to the conclusion that the idea I have is way too complicated due to the fact i also want to integrate data from a form and put it into the pdf or print along side it. my solution to this now is to just re create the pdf in a access report so then I can add data in from a form onto it as well.

Once again thank you for your help.

Matt

MattAnderson is offline   Reply With Quote
Reply

Tags
button , form , macro , pdf , print

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Print Pivot chart form without displaying print button & in colour MichaelWaimauku Forms 3 01-15-2013 12:05 PM
Print mail merge document from Access form using vba aman Modules & VBA 2 09-12-2011 12:25 AM
Access button to print report instead of opening it in print preview vvangogh Modules & VBA 2 07-01-2011 10:45 AM
Print Access Form through search string in web karthikcoep Web Design and Development 4 08-21-2009 12:08 AM
To print a worksheet from access form button aman Modules & VBA 3 04-05-2009 10:49 AM




All times are GMT -8. The time now is 01:27 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World