printing a .pdf form from code

[Brad Pears]

As part of a contract project I am working on, a "Conditions of Sale"
document needs to be produced along with the contract. The contract itself
is a dynamically generated Access 2000 report, but the "Conditions of Sale"
agreement is a static .pdf document. How can I print a .pdf document in
code - as part of the procedure to produce the contract - instead of having
to generate another access report?

Thanks, Brad

 

[Douglas J. Steele]

If it's a static document, why do you need to print it again?

 

[John Nurick]

Hi Brad,

Try using Shell() with a command line like this:

"C:\Program Files\Adobe\Acrobat 7.0\Reader\AcroRd32.exe" /p
"D:\Folder\File.pdf"

Searching Usenet or the Web for something like
"Acrobat Reader" "command line"
should find some more information.

 

[Brad Pears]

You do raise a good point but the application produces all the required
documentation that goes along with the contract (it's more than jksut the
contreact that is produced). I did tell the sales people just to print this
static doc afterwards but they want it all bundled in with the other
contract documentation so it is not forgotten - hence my reason for wanting
to do this... I do a lot of work for our sales dept and yes, they are a
bunch of whiners typically and always seem to get their way because after
all "if it weren't for them we'd be out of business". You don;t know how
many tiems I hear that.

I have decided to convert it to an Access report instead.

Thanks, Brad

 

[Brad Pears]

Thanks John. I decided to create an access report out of it but this will
surely come in handy at some point in the future!!

Brad