[AccessD] Print Reports to Specific Printers WAS Where iseveryone?

I didn't know that.  This customer uses 2000 but that would be handy for others if you can find it.  Thanks!
  ----- Original Message ----- 
  From: Steve Conklin (Developer at UltraDNT)<mailto:Developer at UltraDNT)> 
  To: 'Access Developers discussion and problem solving'<mailto:accessd at databaseadvisors.com> 
  Sent: Thursday, August 11, 2005 9:01 AM
  Subject: RE: [AccessD] Print Reports to Specific Printers WAS Where iseveryone?


  Didn't see if this got answered - are you using Access 2002 or higher?
  Much easier if the answer is yes.  Each report has a printer property
  that is changeable at run-time:

  DoCmd.OpenReport strName, acViewPreview, , "invoiceid=" &
  lngInvID
  Set rpt = Reports(strName)
  rpt.Printer = Application.Printers(DLOOKUP
  ("INVOICEPRINTER","usysUSERSETTINGS","UserID='" & GetUserID & "'"))

  I did an article at http://my.advisor.com/doc/14608<http://my.advisor.com/doc/14608> if you are a
  subscriber.  (I can send it off-line - if I can find it)

  If you are using 2000 or lower, you need PrtDevMode API code
  (http://support.microsoft.com/?id=129397<http://support.microsoft.com/?id=129397>)

  Either way, though, the driver has to get to the workstation, even if
  printing to a network printer via its share name.  These 2 methods can
  only give you a list of printers that properly show up in Ctl
  Panel/Printers.

  Hth
  Steve



  -----Original Message-----
  From: accessd-bounces at databaseadvisors.com<mailto:accessd-bounces at databaseadvisors.com>
  [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gregg
  Sent: Wednesday, August 10, 2005 4:30 PM
  To: Access Developers discussion and problem solving
  Subject: Re: [AccessD] Where is everyone?


  Since everyone is so lonely... I have a general question about setting
  up printers/networks/Access.  The client wants to print copies of Vendor
  Purchase Orders to multiple locations.  I have total latitude with the
  customer on printer setup, network setup and Access. Thus far, I have
  been creating a report for each printer, each having the same subreport.
  I know there is code out there to help me a little with that.  The part
  I really hate is setting up every user with every printer and the
  ongoing maintenance associated with it. 

  I need a magic button that prints a report to the network printers I
  have specified in a table and doesn't care if the printer is configured
  on that workstation or not.  Any ideas?????  

  Gregg Steinbrenner   
    ----- Original Message ----- 
    From: Charlotte Foust<mailto:cfoust at infostatsystems.com<mailto:cfoust at infostatsystems.com>> 
    To: AccessD at databaseadvisors.com<mailto:AccessD at databaseadvisors.com<mailto:AccessD at databaseadvisors.com<mailto:AccessD at databaseadvisors.com>> 
    Sent: Wednesday, August 10, 2005 11:21 AM
    Subject: [AccessD] Where is everyone?


    I haven't seen a message since yesterday afternoon.

    Charlotte Foust
    Infostat Systems, Inc.
    -- 
    AccessD mailing list
    AccessD at databaseadvisors.com<mailto:AccessD at databaseadvisors.com<mailto:AccessD at databaseadvisors.com<mailto:AccessD at databaseadvisors.com>>
   
  http://databaseadvisors.com/mailman/listinfo/accessd<http://databaseadvi<http://databaseadvisors.com/mailman/listinfo/accessd<http://databaseadvi>
  sors.com/mailman/listinfo/accessd>
    Website:
  http://www.databaseadvisors.com<http://www.databaseadvisors.com/<http://www.databaseadvisors.com<http://www.databaseadvisors.com/>>
  -- 
  AccessD mailing list
  AccessD at databaseadvisors.com<mailto:AccessD at databaseadvisors.com>
  http://databaseadvisors.com/mailman/listinfo/accessd<http://databaseadvisors.com/mailman/listinfo/accessd>
  Website: http://www.databaseadvisors.com<http://www.databaseadvisors.com/>

  -- 
  AccessD mailing list
  AccessD at databaseadvisors.com<mailto:AccessD at databaseadvisors.com>
  http://databaseadvisors.com/mailman/listinfo/accessd<http://databaseadvisors.com/mailman/listinfo/accessd>
  Website: http://www.databaseadvisors.com<http://www.databaseadvisors.com/>