Results 1 to 4 of 4
  1. #1
    Kaloyanides is offline Advanced Beginner
    Windows 7 64bit Access 2013
    Join Date
    Jan 2015
    Location
    Arlington, MA
    Posts
    51

    Print Multiple Copies while Keeping Together

    When I print all of the invoices for the day, I auto print two copies of each invoice. One for the customer and one for us.



    If there are 10 invoices, MS Access will print all of the first 10 copies then it will print all of the second copies. We then manually match them up.

    I've dealt with this for years but it's annoying and not easy to fix.

    I've posted this a couple times and one time I received advice about creating a temp table. When I got that response, I was in the middle of a shit-storm, planned to get back to it but have now lost it and can't find it.

    Does anyone know how to print:
    Copy 1
    Copy 2
    Copy 1
    Copy 2

    Instead of:
    Copy 1
    Copy 1
    Copy 2
    Copy 2

    Thanks so much!!!

  2. #2
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,858
    Just print using VBA.
    You then have control. So loop through the recordset for your invoices, as many times as you wish.
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  3. #3
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    Might help us to know how they are different, if in fact they are. Are there 2 separate report objects or are you reusing one and altering a title or something?
    As noted, code will likely be the way to go.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  4. #4
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    bit puzzled why you want to interleave - surely the customer copy goes in the post and your copy goes to accounts?

    but to answer the question create a table with one field and 2 records - populate with any number 1 and 2, even 0 and 0, what matters is the number of records. If you need more copies, add more records

    add this table to your report recordsource and drag the number field onto the grid. Untick the show box and do not link it to any other table

    That is all you should need to do

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Print Invoices (Multiple Copies) AND Keep Together
    By Kaloyanides in forum Reports
    Replies: 13
    Last Post: 08-05-2022, 08:13 AM
  2. Replies: 1
    Last Post: 01-07-2015, 12:04 PM
  3. print multiple copies
    By slimjen in forum Reports
    Replies: 4
    Last Post: 08-14-2014, 06:33 PM
  4. Replies: 3
    Last Post: 02-04-2014, 04:33 PM
  5. Can docmd.openreport print X copies on Y printer?
    By Coolpapabell in forum Reports
    Replies: 1
    Last Post: 09-02-2009, 08:35 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums