473,785 Members | 2,275 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Code to open a report and display the print dialogue box

Hello-

I have a contol button on a form that I want to code to open a report
(rptReviews), then display the print dialogue box so that users can
select a printer. This report needs color, but most of my team has
their default printer set to our departments monochrome printer. Thus
i wanted to give them the option to run it to our color printer during
the print process.

Alternately, is there a way to code a button to drive a report to
print on the color printer on our network?

All ideas are appreciated-

Scott

Apr 17 '07 #1
1 2520
On 16 Apr 2007 20:02:06 -0700, Scott <ss***@henrysch ein.comwrote:

The user can open this dialog by choosing File>Print or Ctrl+P.

If you want to code a "Print to the color printer" button, check out
the Printer object (Access 2002 and better).

-Tom.

>Hello-

I have a contol button on a form that I want to code to open a report
(rptReviews) , then display the print dialogue box so that users can
select a printer. This report needs color, but most of my team has
their default printer set to our departments monochrome printer. Thus
i wanted to give them the option to run it to our color printer during
the print process.

Alternately, is there a way to code a button to drive a report to
print on the color printer on our network?

All ideas are appreciated-

Scott
Apr 17 '07 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
1855
by: kevinm3574 | last post by:
So, I'm doing the following in a php script so that I can fire a download dialogue AND redirect the page (after clicking submit in a form). I'm doing it this way because of the problem with headers and such and server-side vs client-side issues: $dir = "somedir"; $file = "somefile"; print(" <script language=\"JavaScript\">
46
6032
by: Steve | last post by:
Access97 Database The database is split into a frontend and backend and not connected to any other database. The database has an unbound report with 15 subreports. Some of the subreports include Excel charts in unbound object frames. When I add 3 additional subreports, I get the error message that Access can't open any more databases. Can anyone suggest what may be causing the error message. Thanks!
0
1471
by: Mitch | last post by:
Helle everyone, I'm using VS.NET 2005 and the Crystal Report Viewer in an ASP.NET page. When the user click the print button on the viewer toolbar, a Crystal print dialogue/page opens asking to print all or a range of pages. After which the user sees the report as pdf in the browser. How do I bypass the print dialogue/page? When clicking on the print button, I would like to show them the current page only as pdf in the browser. ...
11
2080
by: ladybug via AccessMonster.com | last post by:
I have a form called "EmpRpt". It has three fields. First field is "chrUserID," this is a combo box with a row source from another table. The Second Field is "BeginDate." The Third field is "EndDate." I then have a command button. I want to put a code in this buttons on click event. The code should open up a report called "EmpRpt." The report will have the three fields just like the form. I want those three fields to appear with...
10
11761
by: sara | last post by:
Hi - Is it possible to hide the detail section of a report at run time? I have a report that prints all details, with summary lines. The user would like the report ALSO with just summary lines. It seems the simplest thing is to run the code (see below) once with the detail section showing, and a second time hiding the detail section. I can't figure out the code to do that and don't see it posted.
6
2647
by: meyzhong | last post by:
Hi, I am new to Visual C++ (6.0). I want to put all the print information in different lines into a box. I create a EDIT dialogue box, and then add a CString variable (m_MSG) to the dialogue box to display the print information in the box. However, the print information displayed in the box is in one line, like this "10.0| 20.0". The "\n" character for the change to a new line has not been recognized.
1
3276
by: G Gerard | last post by:
Hello When I want to print a report using code I normally use the following code DoCmd.OpenReport "RptName", acViewNormal This works OK when I'm only printing one copy of the report. What I'm trying to do now is open the CommonDialog using .ShowPrinter and set the number of copies to print from the CommonDialog
2
16685
by: smorrison64 | last post by:
I have a form that is coded to open a File Dialog boc to pick a picture to display on that particular item on a subform. My form is not based on query, but rather two separate tables (one primary, one sub). That code is working properly. How do I get that to translate to my report? I use VBA code because I use formats other than BMP for the pictures. Would basing the form on the qury that the report is based on solve the issue without...
11
7340
by: Gord | last post by:
When I open a certain report, it runs some code that generates the records that will be displayed in that report. This works fine. When I go to print preview the report it appears that the code is run again? This is causing certain error problems. 1 Why does the code run for a print preview when the report already exists? 2 What command do I use in code to find out if a report (or any other object for that matter) is already...
0
9647
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9489
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10162
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10101
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9959
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
7509
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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6744
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 then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
1
4063
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3665
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.