wolf99
May 23rd, 2007, 04:10 AM
Hi am fairly new to reports
am using vb6 DAO
I have a function that queries my access db then outputs the result to a label on the report, in form; partNum, number of parts with partNum, partFault.
Prob is, when I set the label in the detail section, with 3 items from a 10 record db, the label got printed 10 times over 3 pages.
So i moved it to the Page header and got 3 pages, each with the 3 items at the top. wether this is because this is space still used by the 10 records, just hidden, or because of the 3 records Im not sure.
anyhoo, I moved the label to the ReportHeader seection. now the label only prints once (Yay); but I'm still etting three pages, 2 extra blank ones after the first page!
how can i cut the pages to the number needed??
Also how can I ensure the page size is set to A4 and how to specifiy the printer used?
thanks in advance, muchos gracias!
am using vb6 DAO
I have a function that queries my access db then outputs the result to a label on the report, in form; partNum, number of parts with partNum, partFault.
Prob is, when I set the label in the detail section, with 3 items from a 10 record db, the label got printed 10 times over 3 pages.
So i moved it to the Page header and got 3 pages, each with the 3 items at the top. wether this is because this is space still used by the 10 records, just hidden, or because of the 3 records Im not sure.
anyhoo, I moved the label to the ReportHeader seection. now the label only prints once (Yay); but I'm still etting three pages, 2 extra blank ones after the first page!
how can i cut the pages to the number needed??
Also how can I ensure the page size is set to A4 and how to specifiy the printer used?
thanks in advance, muchos gracias!