473,513 Members | 2,595 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Problem for report printing's color

255 Contributor
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:
Expand|Select|Wrap|Line Numbers
  1. Private Sub cmdPrint_Click()
  2. On Error GoTo Err_cmdPrint_Click
  3.  
  4.     Dim stDocName As String
  5.  
  6.     If frameStyle.Value = 1 Then
  7.  
  8.         stDocName = "Washout1"
  9.  
  10.     ElseIf frameStyle.Value = 2 Then
  11.  
  12.         stDocName = "Washout"
  13.  
  14.     End If
  15.  
  16.     DoCmd.OpenReport stDocName, acViewNormal
  17.  
  18. Exit_cmdPrint_Click:
  19.     Exit Sub
  20.  
  21. Err_cmdPrint_Click:
  22.     MsgBox Err.Description
  23.     Resume Exit_cmdPrint_Click
  24.  
  25. End Sub
Jul 5 '11 #1
1 1888
colintis
255 Contributor
I had made a bit of work around to print the report in a semi-auto way: open report -> open print dialog -> print -> close report.
Expand|Select|Wrap|Line Numbers
  1.     DoCmd.OpenReport stDocName, acViewPreview
  2.     DoCmd.RunCommand acCmdPrint
  3.     DoCmd.Close acReport, stDocName
From the print dialog, I found the database itself changes the setting print quality from "Black and White" to "Colour", this doesn't happen to any other databases I worked on, only particularly this one.
Jul 5 '11 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

1
4695
by: Maileen | last post by:
Hi, I have 2 questions : 1. - I want to print from my ASP page directly to my network printer. For this i use the following code, but everytime, my document to print is sent to local and...
1
17381
by: Steven Stewart | last post by:
I have a user who has been using Excel for a while to keep statistics and print reports. She finds using it cumbersome because of long formulas and a lot of copying and pasting. I have designed...
1
1183
by: Deano | last post by:
Hi, I have a report with a subreport. If the subreport has 2 records I get too copies of the report. If it has 3 I get 3 copies. Other than that the report is fine and is producing the data...
1
1960
by: Joe Saliba | last post by:
Hi Folks, am working on an archiving project which they use a little format of paper on which they type on it code and descriptions on each line, and they append on it new lines later on via a...
1
1736
by: Marc | last post by:
Can anyone help me! I'm trying to create an automatic printing process involving an Access database, at present I have 9 different reports set out, what I want is each report to print out using...
2
1711
by: Florifulgurator | last post by:
Hello, trying to clean up other´s mess... I´ve replaced some tables (previously linked to another Access DB) with renamed tables linked to a PostgeSQL DB (removed spaces and Ümlauts in names,...
1
2564
by: Mina Gohari | last post by:
Hi all I have a problem with printing a report card to laser printer. Everything works properly on ink-jet printer, but when I use laser printer , it's not in predifined format. everything is...
5
5461
by: kaosyeti | last post by:
how can i get my report to print all in black when i have a control with conditional formatting to change the font color about 10% of the time it shows up. i've been trying to find a way to format...
10
2837
by: dishal | last post by:
Hi, im having a major problem with printing text on a JFrame. This is a simple whiteboard I'm doing but i just cannot seem to print the text properly. It prints all the alphabets on the same point...
1
4480
by: jessicahagg | last post by:
Hi, Goal: Change report body background color to white at runtime before exporting to pfd format. I am reproducing a web report useing .Net reportviewer -- The report is to have the same...
0
7160
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7537
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
7099
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
7525
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
1
5086
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
4746
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
3233
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
1
799
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
456
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.