473,386 Members | 1,753 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

Printing multiple reports!

Hi all!

I have a problem printing multiple reports. The code i use is:
Dim stDocName As String
stDocName = "rptInvoice"
DoCmd.OpenReport stDocName, acNormal, , "[Invoicedate] = date()"
The problem is that invioce details is printed several times on the same
invoice and only the first page is shown as first page, even if all reports
have only one page.
I gess I have to loop trough the code, but I can't figure out how to.

Sigurd

Nov 12 '05 #1
2 4527
Assuming you are printing multiple invoices per report run. You need to move
your Invoice page header to the Group header of the Invoice number. The
report Header / Footer only prints once per report run

"Sigurd Bruteig" <s-********@online.no> wrote in message
news:Jw********************@news2.e.nsc.no...
Hi all!

I have a problem printing multiple reports. The code i use is:
Dim stDocName As String
stDocName = "rptInvoice"
DoCmd.OpenReport stDocName, acNormal, , "[Invoicedate] = date()"
The problem is that invioce details is printed several times on the same
invoice and only the first page is shown as first page, even if all reports have only one page.
I gess I have to loop trough the code, but I can't figure out how to.

Sigurd

Nov 12 '05 #2

"paii" <pa**@packairinc.com> skrev i melding
news:vn************@corp.supernews.com...
Assuming you are printing multiple invoices per report run. You need to move your Invoice page header to the Group header of the Invoice number. The
report Header / Footer only prints once per report run


Thank you!
I will try this out

Sigurd
Nov 12 '05 #3

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

Similar topics

1
by: John | last post by:
Hi I am looking into Oki ML 590 and ML 591 printers to see if any of these will work with multi-part (multiple copies) continuous stationery for printing invoices from access. Has anyone had any...
16
by: cyranoVR | last post by:
This is the approach I used to automate printing of Microsoft Access reports to PDF format i.e. unattended and without annoying "Save As..." dialogs, and - more importantly - without having to use...
0
by: Ann | last post by:
I have a C# application that uses PrintDocument and PrintPage to draw reports. Now I need to integrate a tax form printing from a legacy VC++ DLL into the C# application. One of the important...
4
by: Russ | last post by:
To ASP.NET printing experts: My Asp.net web form needs to print some reports at the client side. I've been trying to research this and find some confusing and conflicting information in previous...
1
by: Stinky Pete | last post by:
Hi, I've been reading, and successfully tested some code referred to in this group, that allows a user to select a printer before printing a report. The code has worked well on single page...
0
by: John Smith | last post by:
Hello, I have 7 different crystal reports that need to be collated. Since I want to end up with a page of each (which all together make a single report), I created a blank main report and then...
3
by: rush2112 | last post by:
First of all, I'm a nebie at VB code.......so be gentle. I need to print up to 25 reports at the click of a button, but I want to select which reports to print based on whther or not I have a check...
5
by: dancole42 | last post by:
I want to create a button that will print multiple forms. Each form is a list of various orders, and there are three separate forms: -Standard Orders -Rush Orders -VIP Rush Orders Each is...
18
by: Brett | last post by:
I have an ASP.NET page that displays work orders in a GridView. In that GridView is a checkbox column. When the user clicks a "Print" button, I create a report, using the .NET Framework printing...
0
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,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
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...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
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...
0
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
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
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...

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.