When printing multiple copies of multiple reports; keep copies together? (1 Viewer)

Kaloyanides

New member
Local time
Today, 06:37
Joined
Jan 28, 2015
Messages
11
This is something I've struggled with for years. I have never found the solution.

If it ends up being something simple.... erg...

Anyway, I use a database to print invoices. I have the following to print all open invoices for a specified driver. It auto prints two (2) copies of every invoice.

However, it prints all of the 1st copies then all of the 2nd copies and then we manually match them up.

Ideally, MS Access would print 1st copy then 2nd copy, 1st copy then 2nd copy, etc...

Instead of, 1st copy, 1st copy, 1st copy, then 2nd copy, 2nd copy, 2nd copy...

Hope this makes sense...

If anyone knows how to do this, you'll save us extra work everyday...

Many thx in advance!

DoCmd.OpenReport "rptSalesInvoiceEdit", acViewPreview, , , acHidden
DoCmd.SelectObject acReport, "rptSalesInvoiceEdit"
DoCmd.PrintOut acSelection, , , acHigh, Forms![frmPrintPromptSalesOrdersedit].[txtCopies], True
DoCmd.Close acReport, "rptSalesInvoiceEdit"
DoCmd.OpenQuery "qryUpdateSalesInvoicePrintedEdit", acViewNormal, acEdit
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 18:37
Joined
May 7, 2009
Messages
19,175
you create a table (see zzCopies) with 2 records in it.
create a Query that uses zzCopies and your table (see Query1)
see the report in Preview.
 

Attachments

  • TwoCopiesReport.accdb
    544 KB · Views: 149

Users who are viewing this thread

Top Bottom