print to pdf without prompt or dialog box

[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.

 

[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

 

[Song Su]

Got it. Thanks a lot.