Re: Printers

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: "Allen Browne" <AllenBrowne@xxxxxxxxxxxxxx>
Date: Mon, 13 Jun 2005 22:15:52 +0800

The Printers collection and Printer object were introduced in Access 2002,
so that's why it won't work in A2000.

It is possible in A2000 to manipulate the printer. Albert Kallal has the
code here:
http://www.members.shaw.ca/AlbertKallal/msaccess/printch2k.zip
or you can use PrtMip as Ken Getz explains here:
http://www.microsoft.com/AccessDev/Articles/GetzCh10.HTM

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Ernst Guckel" <ErnstGuckel@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:39D130E0-C32C-414E-AAA8-24B5E09C975A@xxxxxxxxxxxxxxxx
>
> for some reason this does not work in Access 2000 but worls fine in 2003.
> Any ideas?
>
> Private Sub cFax_Click()
> sReportName = "rPayroll"
>
> Application.Printer = Application.Printers("WinFax")
> DoCmd.OpenReport sReportName, acViewNormal, _
> wherecondition:="[weDate] = " & Chr(34) & dFilter & Chr(34)
>
> Application.Printer = Nothing
> End Sub
>
>
> Thanks,
> Ernst.

.

References:
- Printers
  - From: Ernst Guckel

Prev by Date: Re: How to Find the Date of Last Change in Inventory
Next by Date: RE: Still Trying re: formula or function
Previous by thread: Printers
Next by thread: BusinessObjects automation
Index(es):
- Date
- Thread

Relevant Pages

Re: Access Form Submit Button
... Private Sub Form_BeforeUpdate ... sort order, closing Access, clicking a navigation button, or triggering any ... rather than allenbrowne at mvps dot org. ... > staffing data we hold. ...
(microsoft.public.access.formscoding)
Re: Default Printer Name
... printer object that I'm using and configuring for reports. ... MsgBox "Default Printer: " & Printer.DeviceName ... > Private Sub Command1_Click ... > default value of a String function is the empty string... ...
(microsoft.public.vb.general.discussion)
Re: Delete
... Private Sub cmdDelete_Click ... BeforeDelConfirm event of the the form to suppress the confirmation. ... rather than allenbrowne at mvps dot org. ... > If I comment out the SetWarnings Statement the record is deleted but I am ...
(microsoft.public.access.formscoding)
Re: Form Design - Data Entry
... > Your other question related to how to tab out of one subform into the next. ... > Private Sub txtJump_GotFocus ... > Allen Browne - Microsoft MVP. ... rather than allenbrowne at mvps dot org. ...
(microsoft.public.access.forms)
Re: Find only specific part of a record
... Private Sub Text0_AfterUpdate ... Dim strWhere As String ... rather than allenbrowne at mvps dot org. ... > containing "chris" as part of the text. ...
(microsoft.public.access.modulesdaovba)