Results 1 to 3 of 3
  1. #1

    Changing Printer in Reports


    Does anyone know of a simple way to change printers while printing various parts of a report. To be specific (to change trays). I want to print e.g pages 1, 3, 8 and 15 from a tray containing headed paper and the others (2,4,,5,6,7,9-14) to a seond tray/printer. The page numbers I have found using some vba and I want to change the active printer depending on the page I am currently printing. The layout of the pages will not change as the printers are the same. I've read that the PRTDEVMODE property is read only when previewing a report.

    Any help or sample code greatly received

  2. #2
    New Lounger
    Join Date
    May 2001
    California, USA
    Thanked 0 Times in 0 Posts

    Re: Changing Printer in Reports

    Hi Jason,

    Here are to Knowledgebase articles that may have your answer. Hope this helps.

    How to change printer trays from Access 2000.

    <A target="_blank" HREF=></A> printer&rnk=6&src=DHCS_MSPSS_gn_SRCH&SPR=ACC2000

    How to use code to change a reports printer.

    <A target="_blank" HREF=></A> printer&rnk=18&src=DHCS_MSPSS_gn_SRCH&SPR=ACC2000


  3. #3

    Re: Changing Printer in Reports

    Thanks for the Access help. I am already using both of those reports, I was just expecting Access97 to offer a more elegant way to produce it.

    At present it looks like i have run run the Format or print Event of a report to get all the page numbers. (Page numbers at Group Headers are on a different priter)
    Then loop through pages choosing correct printer before opening and printing report.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts