I have a simple database to print reports in the company, but the default setting for the printer seems different. The printer's default setting will print all pages in black and white, even the reports don't have any colors as well.
When a print button is clicked, the procedure automatically changed to print in color; because a login is required if the quality is set to color in the company printer. I have no idea why only this database will do this itself. The VBA code for the button is as follows:
When a print button is clicked, the procedure automatically changed to print in color; because a login is required if the quality is set to color in the company printer. I have no idea why only this database will do this itself. The VBA code for the button is as follows:
Code:
Private Sub cmdPrint_Click()
On Error GoTo Err_cmdPrint_Click
Dim stDocName As String
If frameStyle.Value = 1 Then
stDocName = "Washout1"
ElseIf frameStyle.Value = 2 Then
stDocName = "Washout"
End If
DoCmd.OpenReport stDocName, acViewNormal
Exit_cmdPrint_Click:
Exit Sub
Err_cmdPrint_Click:
MsgBox Err.Description
Resume Exit_cmdPrint_Click
End Sub
Comment