Results 1 to 2 of 2
  1. #1
    uoghk is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Jan 2022

    change specific printer when print reports

    I have several laser printers to print reports. I can use Page Setup>Use Specific Printer to set different reports to different printers.
    But if I buy new printers, I need to changes all the related reports.

    Is there any easy ways to solve it?

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    The Great Land
    Could write code that opens each report, changes report properties and save with changes. Would probably have to first build a table that holds report names and printer to use. Not sure all that is easier than just manually editing.

    Or instead of setting printer in report properties, could use VBA to change destination printer. Again, a ReportPrinter table would be useful.
    How to attach file: 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: 09-07-2015, 08:00 AM
  2. Print to other than default printer with code
    By dmgg in forum Programming
    Replies: 13
    Last Post: 08-28-2015, 06:14 PM
  3. Print to Default Printer
    By bsc0617 in forum Access
    Replies: 7
    Last Post: 10-10-2013, 07:46 AM
  4. Replies: 3
    Last Post: 09-18-2013, 04:03 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