How do I use Access 2007 VBA to print external pdf files?

's Computer Specifications

Ideally, I'd like to use an Access form to open the pdfs, print them and
then close Adobe Reader or whatever program is used to do the print job.

's Computer Specifications

On Fri, 28 May 2010 09:43:20 -0700, "LA Lawyer" <(E-Mail Removed)>
wrote:

You can use the ShellExecute API with the Print verb (the lpOperation
argument). That's what Windows uses when you drop a PDF document on a
Printer. Check out this article:
http://www.mvps.org/access/api/api0018.htm

-Tom.
Microsoft Access MVP

>Ideally, I'd like to use an Access form to open the pdfs, print them and
>then close Adobe Reader or whatever program is used to do the print job.
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Print Report to PDF with .pdf Name and Print Driver coded	rwboyden via AccessMonster.com	Microsoft Access External Data	3	7th Feb 2008 08:12 PM
Access VBA - declared an Excel VBA reserved word and VBA/Access won't give it back!	ultar6@gmail.com	Microsoft Access	1	16th Jun 2007 05:11 AM
print PDF file from Excel - NOT print Excel to PDF?	Alan Ibbotson	Microsoft Excel Programming	1	28th Dec 2006 05:03 AM
Sort and print .pdf files into one .pdf document via VBA code?	cyberbuild@gmail.com	Microsoft Excel Misc	0	3rd Jun 2006 02:11 PM
VBA Access Print Multiple Reportpages to separate pdf files	=?Utf-8?B?RnJhbms=?=	Microsoft Access Reports	0	5th Oct 2005 04:40 PM