There are times in my database that I might like to output some things to a
PDF file instead of the the normal printer.
Is there a way, via VBA, to switch back and forth between my regular printer
and a PDF output file, and if yes, how is that done?

"Bill Agee" <wscs (AT) mindspring (DOT) com> wrote

I think when I installed Adobe that it came with a print driver for PDF. So
it might seem that you could print to the PDF file by selecting the printer.
I am assuming by the post you made that you installed the PDF printer (Save
to disk) drivers as well as the software. I know at home I sometimes will
tell the print selection to use the PDF driver to save instead of actually
printing to a physical device. Sometimes I only want to reference something
later, but don't want a hard copy; so this is a nice use of that driver
also.

Tim

It is also important to note, that you have to have a full functioning
version of Acrobat. The reader is not enough.

Mike

--
MEDICATION ASSISTANCE PROGRAM
Qualifying applicants get their medication free.
It's easy to qualify. Use the qualification wizard at
http://www.rexaid.com




"Parts Manager" <partsmanager (AT) howardmoe (DOT) com> wrote

if you are using Access 2k2 and above, you have the availability to set the
output printer using Set Application.Printer. We use PDF995 to print to pdf
on specific reports and use code similar to the following:

Set Application.Printer = Application.Printers("PDF995") 'Set the output
printer
DoCmd.OpenReport "ReportName" 'Print
Report
Set Application.Printer = Nothing
'Reset printer to default.

HTH,
J. Clay


"Bill Agee" <wscs (AT) mindspring (DOT) com> wrote





http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----