changing printersettings for two reports

  • Thread starter Thread starter Johansac
  • Start date Start date
J

Johansac

In the access file i use i have two reports that need a different setting for
the printer, those settings are on tractorfeed papers, yes they still excist.
How can i put the changes in the structure so the changes take place when the
report is opened in printview before printing them out.

I use ACCESS 2003 with the XP platform all updates are applied to both the
office pack and the xp pack
 
Johan:

To do this you need to use the Application's Printers object, setting it to
use the tractor feed printer prior to opening the report. You also need to
set the report to use the default printer. The code to do this is below.
--
SA
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg

Public Function SetAppPrinter(strPrinterName As String)
On Error Resume Next
Dim objPrn As Object
Dim App As Object
Dim strPrinter As String
Set App = Application
If Val(SysCmd(acSysCmdAccessVer)) >= 10 Then
For Each objPrn In App.Printers
strPrinter = objPrn.DeviceName
If strPrinter = strPrinterName Then
Set App.Printer = objPrn
End If
Next
End If
End Function
 
Thanks for this I will try it out and let you know, thanks for the link too,
giving some interesting options there

Johan
Johan:

To do this you need to use the Application's Printers object, setting it to
use the tractor feed printer prior to opening the report. You also need to
set the report to use the default printer. The code to do this is below.
In the access file i use i have two reports that need a different setting
for
Click to expand...
[quoted text clipped - 6 lines]
I use ACCESS 2003 with the XP platform all updates are applied to both the
office pack and the xp pack
Click to expand...
Click to expand...
 
Back
Top