Print 2 different reports at the same time

Greg

I have 2 reports that are almost the same one is for internal use and the
other is for the customer. The Internal report has a few extra fields then
the customer report. The customer report has a criteria that the Internal
report does not have so the customer will not see all the notes added for a
job. Both reports the user has to put the customer code in for the report.
How can I get this so that when they want both reports they just click a
button instead of having to open both reports and type in the same code?
Thanks,

Greg

Nov 12 '05 #1

Subscribe Post Reply

2604

Larry Linson

Create a Form into which the user can enter the Customer Code, and use that
one entry to construct the Where Condition for a DoCmd.OpenReport for each
of the two reports. You'll need to remove the parameter / criterial from the
Reports' Queries, that I infer is what's being typed in now.

Larry Linson
Microsoft Access MVP

"Greg" <gk******@itlan.net> wrote in message
news:vq************@corp.supernews.com...

I have 2 reports that are almost the same one is for internal use and the
other is for the customer. The Internal report has a few extra fields then the customer report. The customer report has a criteria that the Internal
report does not have so the customer will not see all the notes added for a job. Both reports the user has to put the customer code in for the report. How can I get this so that when they want both reports they just click a
button instead of having to open both reports and type in the same code?
Thanks,

Greg

Nov 12 '05 #2

Greg

Thanks for the Help .........

Greg

"Greg" <gk******@itlan.net> wrote in message
news:vq************@corp.supernews.com...

I have 2 reports that are almost the same one is for internal use and the
other is for the customer. The Internal report has a few extra fields then the customer report. The customer report has a criteria that the Internal
report does not have so the customer will not see all the notes added for a job. Both reports the user has to put the customer code in for the report. How can I get this so that when they want both reports they just click a
button instead of having to open both reports and type in the same code?
Thanks,

Greg

Nov 12 '05 #3

Similar topics

Print template

by: yooyoo | last post by:

I am implementing print template solution. I would like to use it in asp app. I open new document then generate print preview then print and finally close preview window, but I am not able to close...

ASP / Active Server Pages

How do I print this (easily?)

by: Jonathan Smith | last post by:

Hi In order to make it easier for my colleagues to write their school reports I thought I might attempt to write a (simple) program. At the moment I am working mentally through the steps I would...

.NET Framework

Print Reports

by: Ian | last post by:

(Sorry if I have repeated this, it did not appear the first time) I have the following code on a button. The idea is that when this button is clicked it prints several reports automatically then...

Microsoft Access / VBA

controling which report to print in VB

by: Claudia Fong | last post by:

Hi, I have 4 reports created in Ms-access and I will use VB to print those reports. My problem is I'm not sure if I can control wich report to print.. Those reports are almost the same, what...

Microsoft Access / VBA

Is it possible to get Crystal Reports to print multiple reports in ASP.NET?

by: Rod | last post by:

We've got an old VB6 application which has 9 Crystal Reports it can print. These 9 reports are considered by our users to be in essence one "report", in the sense that they are all related and they...

ASP.NET

VB.NET --> ReportViewer --> 1st Print Job always gets ignored

by: Cam | last post by:

Hello, I am using vb.net 2005 with the report viewer control and the built-in reports (NOT CRYSTAL REPORTS). I have two datasets, two binding controls and two data table adapters. One complete...

Visual Basic .NET

Print reports to a specific printer and manual feed tray

by: AllusiveKitten | last post by:

Hi kind and helpful people... At work I am creating a database and reports that will be used by multiple people. What I need is for my reports to print to a specific colour printer and be manual...

.NET Framework

Print a report 3 times with 3 different fields visible

by: Studiotyphoon | last post by:

Hi, I have report which I need to print 3 times, but would like to have the following headings Customer Copy - Print 1 Accounts Copy - Print 2 File Copy -Print 3 I created a macro to...

Microsoft Access / VBA

Formatting datetime when including in a PRINT command etc...

by: Tim | last post by:

Folks, I'm trying to format a print string so that it reports progress whilst processing a looping structure with a date time stamp appended to the end of the string. This started out life as a...

Microsoft SQL Server

access 2007 will not print report

by: Snoopy33 | last post by:

I have a DB that I developed on access XP (2002) and deployed over a year ago. No one has had problems printing any of the reports within the DB until we started loading 2007 on new computers. ...

Microsoft Access / VBA

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

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,...

General

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

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...

Windows Server