print to pdf without prompt or dialog box

S

Song Su

I want a command button to print a report to pdf without user's interaction
(no prompt, no dialog box or overwritten prompt).

My report name is: rptName
My printer driver is: CutePDF Writer
I want file in: S:\apps\phonebook\
The file name is: phone.pdf

Can anyone help me with the vba code? Thanks.
 
A

Albert D. Kallal

The cute pdf writer does not supprot automaton, and thus you can't supply
the outpu file name.

Fruhter, you have to isntall cutepdf as a priner, and ufthter more you then
have to swith ms-access to that printer.

You better off to dump the cutePDf and use stehpans soltiostn here:
http://www.lebans.com/reporttopdf.htm

Advantages
you don't have to install software on the target machine
(you do have to place one .dll on the target machine)

You don't have to switch printers and a printer driver is
not installed

You can supply the output pdf file name in code, no user
prompts

It is 100% free, and considerable less hassle then cutePDf
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

open pdf after printed 3
Saving a report as a pdf automatically 2
Print hyperlink when saving to PDF. 1
Macro to email PDF file 3
Create Button to Print Report to PDF 1
Print to PDF code for both Cute PDF and Adobe 1
Print directly to PDF Files 4
Using report names for Report To PDF 3

Top