473,503 Members | 11,508 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

How to Print a selection of forms from 700+ records

4 New Member
Hey guys,

I have currently 700+ Reports in a database and i was printing each client out on their own page with all the relevant information so i can backup our database on paper.

Sadly the printer crapped out halfway through. I dont want to reprint it all as half will be wasted so im wondering if i can somehow select the clients (300-700) and print all them out but leave the rest.

Sadly though i cant seem to do it with any filters.

Any help would be greatly appreciated.

Regards, Nick
Jan 5 '07 #1
2 1196
ADezii
8,834 Recognized Expert Expert
Hey guys,

I have currently 700+ Reports in a database and i was printing each client out on their own page with all the relevant information so i can backup our database on paper.

Sadly the printer crapped out halfway through. I dont want to reprint it all as half will be wasted so im wondering if i can somehow select the clients (300-700) and print all them out but leave the rest.

Sadly though i cant seem to do it with any filters.

Any help would be greatly appreciated.

Regards, Nick
Modify the underlying Record Source for the Report and make it reflect only the Records that need to be printed.e.g. [Client_ID] >= 300. When the Report is Opened/Printed, only the appropriate ones will be dumped to the Printer.
Jan 5 '07 #2
NeoPa
32,557 Recognized Expert Moderator MVP
Do you mean a single report with 700+ pages?
If so, then Print Preview the report and just select the from and to pages to print.
Jan 6 '07 #3

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

Similar topics

1
2105
by: DD | last post by:
I have a mainform with a subform. The main form as a dropdown box "chooseDate", in the afterupdate event i requery the subform so all records with the same date are viewed. Now i only want to...
1
238
by: DD | last post by:
I have a mainform with a subform. The main form as a dropdown box "chooseDate", in the afterupdate event i requery the subform so all records with the same date are viewed. Now i only want to...
6
9377
by: Dave | last post by:
On my form I have combo boxes. These combo boxes, after updating them, populate respective listboxes that are located below the combo boxes on the same form. I am trying to use a "generate...
1
11448
by: kirkus84 | last post by:
I am currently trying to do a multiple record mail merge through a query via a command button on a form. The query basically displays customers who have said yes to privacy. The user inputs a date...
0
7212
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,...
0
7098
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
7296
Oralloy
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,...
0
7364
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
7017
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
7470
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...
0
4696
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
1524
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 ...
1
751
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.