Printing a report to .PDF converter

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

 

[Steve Schapel]

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.

 

[Guest]

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

 

[Steve Schapel]

Barb,

Yes, you can do this... but not with macros. You would need to use a
VBA procedure. For an example of one way to do this, see the 'Printer
change code' section at
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

 

[Guest]

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

 

[Steve Schapel]

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

 

[Guest]

thank you
Barb