Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Nevada, USA
    Posts
    207
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Direct Report to Alternate Printer (Access 2000 SR1)

    Could someone please point me in the direction of VBA code that directs a report to a printer other than the default printer. I know that it has something to do with the prtdevnames property but a sample piece of code would be most helpful. My application will be running on a Win 2K machine with one parallel (the default) and one serial printer.

    Thanks.
    Carol W.

  2. #2
    Star Lounger
    Join Date
    Dec 2001
    Location
    Birmingham, Alabama USA
    Posts
    95
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Direct Report to Alternate Printer (Access 2000 SR1)

    Here is a couple of links that may get you headed the right direction.

    <A target="_blank" HREF=http://www.microsoft.com/AccessDev/Articles/GetzCh10.HTM>Controlling Your Printer in Microsoft Access</A>

    <A target="_blank" HREF=http://support.microsoft.com/default.aspx?scid=kb;EN-US;q129397>How to Change a Report's Printer Using Code</A>

    HTH
    RDH
    Ricky Hicks
    Microsoft MVP
    Birmingham, Alabama USA

  3. #3
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Nevada, USA
    Posts
    207
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Direct Report to Alternate Printer (Access 2000 SR1)

    Thanks for the references.

    Does anyone know where I can obtain the ch10.mdb file referred to in <A target="_blank" HREF=http://www.microsoft.com/accessdev/articles/getzch10.htm>http://www.microsoft.com/accessdev/a...s/getzch10.htm</A>?

    Thanks.
    Carol W.

  4. #4
    Star Lounger
    Join Date
    Dec 2001
    Location
    Birmingham, Alabama USA
    Posts
    95
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Direct Report to Alternate Printer (Access 2000 SR1)

    I have a copy of the file in Access 97 version. If you will email me, I will send you a zipped copy.

    rdhicks@mindspring.com

    HTH
    RDH
    Ricky Hicks
    Microsoft MVP
    Birmingham, Alabama USA

Posting Permissions

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