Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2002
    Posts
    61

    Question Unanswered: Printing Specific Pages of a report to different Printers

    How would I go about printing specific pages to different printers based upon the grouping of the report. For example I have a report that lists data exclusive to a particular Unit (i.e. Sales, Tech Support, Shipping, etc.) . How can I print the pages that apply to the sales department to print on the sales printer?

    Thank again

  2. #2
    Join Date
    Jul 2002
    Location
    Romania
    Posts
    122
    If you use Access XP, it has a new collection : Printers

    You can use code in the report to detect which pages belong to which groups, fill in an array of pages, then loop through the array, change the default printer as needed and use the PrintOut method...

  3. #3
    Join Date
    Oct 2002
    Posts
    61

    Talking

    I have XP on my production machine but the application machines are running 2K. Thank you for your suggestion.

Posting Permissions

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