Results 1 to 3 of 3
  1. #1
    odlarhg is offline Novice
    Windows 10 Access 2016
    Join Date
    Jun 2020
    Posts
    5

    How can I create a report that automatically generates copies of the original print?

    Hello,



    Could someone give me an idea of how to get a duplicate and a triplicate generated automatically when printing a report. I have a report created that is similar to an invoice and the requirement is that when it is automatically printed, the duplicate is generated and the triplicate is printed as well. The problem is that hundreds of forms will be printed automatically from this report and each one of them has to be duplicated and tripled.

    There is a way to do this with Access without coding in a development tool outside of Access.

    P.S. Pardon me if I made a mistake while writing, but I speak little English.

  2. #2
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 10 Access 2016
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    Simplest way would be to just repeat your DoCmd.OpenReport line as many times as you need copies of each report
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  3. #3
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    or DoCmd.PrintOut method has an argument for number of copies. Also has a CollateCopies argument but I am not sure what it does.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Replies: 1
    Last Post: 01-07-2015, 12:04 PM
  2. print multiple copies
    By slimjen in forum Reports
    Replies: 4
    Last Post: 08-14-2014, 06:33 PM
  3. Replies: 5
    Last Post: 03-03-2014, 11:07 PM
  4. Replies: 3
    Last Post: 02-04-2014, 04:33 PM
  5. Automatically generated Copies of Access
    By arunsule in forum Access
    Replies: 4
    Last Post: 08-04-2011, 06:01 AM

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