Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Apr 2001
    Location
    Guatemala City
    Posts
    515
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Using multiple printers (Win XP Access 2003)

    I want to print invoices for three different companies from one PC. Each printer will have it's own pre-printed invoice and invoice numbering system. How do I go about selecting the desired printer, maybe using an option box? Any ideas?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Using multiple printers (Win XP Access 2003)

    You can set the printer when the report has been opened in preview mode. For example:

    Dim prt As Printer
    DoCmd.OpenReport "rptInvoices", acViewPreview
    With Reports!rptInvoices
    Set prt = .Printer
    Select Case Me.grpPrinters
    Case 1
    Set .Printer = Application.Printers("HP")
    Case 2
    Set .Printer = Application.Printers("Epson")
    Case 3
    Set .Printer = Application.Printers("Canon")
    End Select
    DoCmd.PrintOut
    Set .Printer = prt
    End With

    Note: this requires Access 2002 (XP) or later.

Posting Permissions

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