Print 1 copy black, pause, print 1 copy color

[boxboxbox]

Is it possible to do all this with one button click: Print one copy of a report in black, then have the program pause about five seconds, then print another copy of the same report in color?

We print our invoices on half sheets, and right now we print a black/draft copy (for us), turn the paper around to start at the other end, then print a color/normal copy for the customer...

Theoretically we could print them on two different pages, then print someone else's on the other ends, but we generally have odd numbers of invoices to print.

Thanks

 

[Trendsetter]

You could build a "work round"
Have your standard black invoice called from code:
DoCmd.OpenReport "rptInvStd"
Then put in a message box:
If Msgbox ("Did the invoice print OK?", vbYesNo) = VbYes then DoCmd.OpenReport "rptInvCol"
rptInvCol would be the same report but with colour formatting - the Std invoice would be set at the top of the A4 and the Col invoice would be set at the bottom of the A4. The msgbox would give you time to mess about.

 

[boxboxbox]

Thanks. Having a message box would probably work great, for pausing and confirmation, and I think I can figure out how to create one in code, but I'm not sure what the A4 is...Should I create two different reports--and try to format one in color and one in black?

 

[Trendsetter]

Yes - exactly!
You said that you printed two invoices on one sheet, I think that you should do the color one first and then if you need a copy the message box will pause the process until you decide if you want a copy or another color invoice.
If you need further help let me know.