Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2005
    Posts
    1

    Unanswered: Print one report to multiple network printers

    I have a daily schedule that we would like to print to 6 different network printers (different model printers too).

    Possible to create a macro or module that would automatically print this single report to multiple printers?

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    dunno
    I'd try creating a PDF then distribute that PDF

    thinking aloud could you copy a file in a dos command or shell to a specified netwrok printer

    you used to be able to pipe output to a printer, wonder if copy file.name > \\printer\queue would work

  3. #3
    Join Date
    Nov 2003
    Location
    LONDON
    Posts
    238
    If you are using Access 2003 (or Access XP) then it is very easy to change the printer that is being used. you need to use the Application.Printer object to change the printer currently in use - see Help on how to use the object.

    I think earlier versions of Access didn't have this object and you had to use API's or other work arounds
    Justin

Posting Permissions

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