Results 1 to 2 of 2
  1. #1
    PhoenixFyre is offline Novice
    Windows Vista Access 2007
    Join Date
    Jun 2012
    Posts
    1

    Printing multiple reports at one time (front to back and top to bottom)

    I have three reports APart1, AExSig, and APart2. Each report consist of two pages that I need to print double sided and top to bottom. Working with macros I have managed to get all three reports to open at one time and the print screen to open for each, however I then have to click properties and select double sided top to bottom to print for each. is there a way to make this all one action either through a macro or code? Thanks for the help.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,929
    I do this with VBA. Some of our printers can duplex and some can't. Example extracted from my procedure:
    Code:
        'open report in preview mode because is only way to change bin and/or printer destinations without changing report saved setup
    strPrinter = Application.Printer.DeviceName
    strReport = "report name here"
    intView = MsgBox("View the report before printing?", vbApplicationModal + vbQuestion + vbYesNoCancel + vbDefaultButton2, "Reports")
    If intView <> vbCancel Then
        DoCmd.OpenReport strReport, acViewPreview, , "Submit.LabNum='" & strLabNum & "'", acWindowNormal
        If strPrinter Like "*Konica*" Then Reports(strReport).Printer.Duplex = acPRDPSimplex
        Reports(strReport).Printer.PaperBin = acPRBNAuto
        If strPrinter Like "*Konica*" Then
            'Set the report destination paper bin to Tray 2 to print on yellow paper
             Reports(strReport).Printer.PaperBin = acPRBNLower
        End If
        If strPrinter Like "*Konica*" Then
            Reports(strReport).Printer.Duplex = acPRDPHorizontal
        End If
        If intView = vbNo Then DoCmd.PrintOut acPages, 1, IIf(strPrinter Like "*Konica*", 2, 1)
        If strPrinter Like "*Konica*" Then Reports(strReport).Printer.Duplex = acPRDPSimplex
        Reports(strReport).Printer.PaperBin = acPRBNAuto
        If intView = vbNo And Not strPrinter Like "*Konica*" Then
            If Not strPrinter Like "*Konica*" Then MsgBox "Add paper or turn sheet over to print on reverse then click OK.", vbApplicationModal, "Print"
            DoCmd.PrintOut acPages, 2, 2, , IIf(strPrinter Like "*Konica*", 1, 2)
        End If
        If intView = vbNo Then DoCmd.Close acReport, strReport, acSaveNo
    End If
    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. Printing multiple reports for one record
    By brew in forum Programming
    Replies: 3
    Last Post: 11-18-2011, 10:01 AM
  2. Replies: 3
    Last Post: 05-23-2011, 01:52 PM
  3. Printing multiple reports at once based on condition
    By justinwright in forum Reports
    Replies: 24
    Last Post: 04-13-2011, 01:40 PM
  4. Different passwords on front-end & back-end?
    By Delta223 in forum Access
    Replies: 3
    Last Post: 01-07-2011, 09:25 AM
  5. Printing multiple reports with one command
    By AKQTS in forum Reports
    Replies: 2
    Last Post: 09-24-2010, 09:32 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