PrintOut Issues

[Stephanie]

Hello,

2 issues - the first is that when I enter in the PrintOut
function to print out 2 copies - it only prints one. The
second issue is that it always prints a page after it that
states the location of the macro and the date. How do I
get it to stop this - when I print multiple reports its an
issue

 

[Steve Schapel]

Stephanie,

This is odd. Can you please give a bit more information, such as which
version of Access, the exact argument settings for the PrintOut action,
what other actions are also in the macro, where/how you are triggering
the macro, and what is the wording of this extra printing of macro
location and date. Thanks.

 

[Guest]

Hi Steve,

I have Access 2002. I have the query before this open a
report than the next command is PrintOut

Print Range: All
Page From: (left blank)
Page To: (left blank)
Print Quality: High
Copies: 2
Collate Copies: Yes

I figured out how to get rid of printing the extra page
(it gives me pop up box about printing arguments and I
press cancel -this is annoying in itself) but it refuses
to print 2 copies. I even tried changing my default
printer! Let me know if you can offer any advice

 

[Steve Schapel]

Stephanie,

Well, reading between the lines, I suspect you may have an OpenReport
action in your macro... am I right? With its View argument set to
Print? So what is happening is the OpenReport is printing one copy of
the report, and then the PrintOut action is printing the currently
active object... which isn't the report.

A possible solution is to make a macro just with the OpenReport, and
then another macro with a RunMacro action to run the first macro, and
set its Repeat Count argument to 2.

Otherwise you need to open the report in Preview, and then using
PrintOut is sometimes a bit tricky because you have to make sure it has
the focus at the time.

 

[Stephanie]

That makes sense!

Thank you so much!

-----Original Message-----
Stephanie,

Well, reading between the lines, I suspect you may have an OpenReport
action in your macro... am I right? With its View argument set to
Print? So what is happening is the OpenReport is printing one copy of
the report, and then the PrintOut action is printing the currently
active object... which isn't the report.

A possible solution is to make a macro just with the OpenReport, and
then another macro with a RunMacro action to run the first macro, and
set its Repeat Count argument to 2.

Otherwise you need to open the report in Preview, and then using
PrintOut is sometimes a bit tricky because you have to make sure it has
the focus at the time.

--
Steve Schapel, Microsoft Access MVP



.