[AccessD] Printing Documents from VBA

Found this:

http://www.dbforums.com/microsoft-access/1066955-how-do-i-print-txt-file-vba
.html

And it seems to work on .doc, .rtf, and .pdf.

Rocky
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Thursday, April 15, 2010 10:32 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Printing Documents from VBA

Dear List:

The app prints a packing list.  One of the fields in the packing list detail
points to a document - a lot certification that needs to go with the packing
slip.  So I want to send those docs to the printer after the packing slip is
printed.  The doc may be a pdf but can't guarantee that.

Is there a general case command that could send a doc to the printer (the
association of the extension should trigger the right app, I think)?

 

MTIA

 

Rocky Smolin

Beach Access Software

858-259-4334

www.e-z-mrp.com <http://www.e-z-mrp.com/> 

www.bchacc.com <http://www.bchacc.com/>