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
Access 2007: external txt data	Gasperix	Microsoft Access External Data	1	28th Jul 2008 03:44 PM
Getting external data from Access 2007 using msquery	terry????????	Microsoft Excel Misc	0	19th Jun 2008 05:16 PM
insert Access 2007 database table into a Word 2007 doc and print	=?Utf-8?B?TGVlZGVsbA==?=	Microsoft Word Document Management	0	20th Oct 2007 08:10 AM
Hyperlinking in PowerPoint 2007 to external zip files	=?Utf-8?B?QnJpYW4=?=	Microsoft Powerpoint	4	28th Jul 2007 05:32 PM
Print various External documents from Access	Darleen	Microsoft Access	3	29th Oct 2004 01:17 PM