Object method - multiple print

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Wayne-I-M - 20 Jan 2008 13:13 GMT

Hi

I have a report that I need to filter then print a number of copies (5) all
the same.

I have used some code which includes DoCmd.SelectObject and DoCmd.PrintOut
but - It looks a mess (to the users) as the report opens then prints then
closes.

Apart from just running
DoCmd.OpenReport "ReportName", acViewNormal, .........
5 times

Is there a way to print 5 copies of the same (filtered) report.

I can't use DoCmd.SelectObject acReport, "SomeReportHere", True
DoCmd.PrintOut acPrintAll , , , , 5
As the report needs to be filted.

Any ideas

Signature

Wayne
Manchester, England.

Reply to this Message

Douglas J. Steele - 20 Jan 2008 14:03 GMT

Try

DoCmd.OpenReport "ReportName", acViewPreview, .........
DoCmd.PrintOut acPrintAll , , , , 5
DoCmd.Close acReport, "ReportName"

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

> Hi
>
[quoted text clipped - 17 lines]
>
> Any ideas

Reply to this Message

Wayne-I-M - 20 Jan 2008 14:42 GMT

Hi Douglas

No - "very" strange with this you get 1 copy of the report and 5 copies of
the popup form.

If Me.ticklSPcards = -1 Then
DoCmd.SetWarnings False
DoCmd.OpenReport "rptCard", acViewNormal, "", "Filter Is Here",
acNormal
DoCmd.PrintOut acPrintAll, , , , 5
DoCmd.Close acReport, "rptCard"
DoCmd.SetWarnings True
End If

I think it may be just "one of those things" :-)
I can use the normal print (5 times). I just assumed there would be a more
elegant method.

Thanks for the input anyway Douglas

Signature

Wayne
Manchester, England.

> Try
>
[quoted text clipped - 23 lines]
> >
> > Any ideas

Reply to this Message

Douglas J. Steele - 20 Jan 2008 15:51 GMT

Note that I suggested using acViewPreview, not acViewNormal.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

> Hi Douglas
>
[quoted text clipped - 47 lines]
>> >
>> > Any ideas

Reply to this Message

Wayne-I-M - 20 Jan 2008 16:26 GMT

Perfect.

Many thanks Douglas

Signature

Wayne
Manchester, England.

> Note that I suggested using acViewPreview, not acViewNormal.
>
[quoted text clipped - 49 lines]
> >> >
> >> > Any ideas

Reply to this Message