print to pdf without prompt or dialog box

  • Thread starter Thread starter Song Su
  • Start date Start date
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.
 
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
 
Back
Top