PrintOut Macro

P

pauld

I noticed a lot of posts on how to use VBA to print one page of a multi-page
Report, but I'd like to ask about how to use the MS Access macros instead.

Do I first use the OpenReport macro to open the report in "Print" mode and
then use the PrintOut macro to specifiy pages 1 thru 1 and then use the Close
(Report) macro to close the Report ?

Thanks.
 
D

Douglas J. Steele

You need to open it in Print Preview mode. Opening in Print mode will print
it.
 
A

Albert D. Kallal

pauld said:
I noticed a lot of posts on how to use VBA to print one page of a
multi-page
Report, but I'd like to ask about how to use the MS Access macros instead.

Do I first use the OpenReport macro to open the report in "Print" mode and
then use the PrintOut macro to specifiy pages 1 thru 1 and then use the
Close
(Report) macro to close the Report ?

Thanks.
Click to expand...

That sounds about 100% right on.

Your where clause needs no quotes, and will look much like:

[ContactID]=[Forms]![Contacts]![ContactID]
 
Top