If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Reset page number on invoice forms
All,
I am running Access via Office XP Pro on Windows 7. Background: I am working on an invoice "form" report. (By form I mean the actual form that I will hand the customer versus an data entry form.) I have it pretty much working thanks to different members on this form, but I have another question. For this report Work Order number is also used as the invoice number. The report is comprised of the following parts: Main report: row source is qrytblWorkOrder table (Invoice rcd) WorkOrder Header - Grouped by Work Order / Inv No # Detail Page Footer Sub-report – row source is qrytblWorkOrderDet table (transactions) WorkOrder Header - Heading for detail line via Repeat Section = Yes Grouped by Work Order / Inv No # Detail WorkOrder Footer - Invoice totals Here are my questions. 1. After each invoice (group) on the main report prints, I want to reset the values Page and Pages. I want the first page of each invoice to be page 1, the second page 2, etc. for each invoice. And I want to be able to print Page x of y in the page footing of the invoice where “y” is the number of pages for the specific invoice. 2. I want to be able to have my details print across the pages. I was testing my report and I move my sub-report down a couple of lines. Before I did that, all of my details printed on the first page. After I moved down the sub-report in design mode, all of the details printed on the second page and none printed on the first page. The first page was 3/4 empty. I have set the Keep Together property of the Sub-report, WorkOrder Header and Detail section of the sub-report to No. But that did not change anything. Any suggestions? Thanks, Dennis |
Thread Tools | |
Display Modes | |
|
|