[AccessD] Print Reports to Specific Printers WAS Where is everyone?

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 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)

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] 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> 
  To: 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>
 
http://databaseadvisors.com/mailman/listinfo/accessd<http://databaseadvi
sors.com/mailman/listinfo/accessd>
  Website:
http://www.databaseadvisors.com<http://www.databaseadvisors.com/>
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com