Printing a report to .PDF converter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to know how to create a macro which will print a selected report
to my .pdf converter. I would appreciate any help you can give. cheers.
 
Ben,

Go to the design view of the report, then to the File|Page Setup menu.
On the Page tab of the Page Setup dialog, select 'Use Specific Printer'
and then nominate your PDF writer. Then, if you use an OpenReport
action in your macro, it will print the report to PDF.
 
Hi Steve
Is it possible to change a printer at run time. Let say have two buttons,
one would print to PDF and another to the printer? Or do I have to have two
identical set of reports assigned to different printers to get this result?

Thanks
Barb
 
Thanks Steve
You always come through...
That was simple, by the way what would you sugest as a good (Simple) book
when I'm just starting with VBA?

Barb
 
Barb,

John Viescas has written a couple of fantastic books lately. They are
not "simple" books, but they are comprehensive in that they cover the
basics as well as more advanced topics, and presented in an easy to
understand style. There is a lot of very good information about using VBA.
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
 
Back
Top