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
|
|||
|
|||
Print a Report for each record in a table
I have a form based on a table. I can print a report on each record one at
a time. If I print the report for ALL records, I get one report header and one report footer. How can I print reports for ALL records and get a report header/footer on each record's report? Right now I would have to select each record and print it. |
#2
|
|||
|
|||
Print a Report for each record in a table
Hi David
move the information out of the report header & footer into the page header & footer (if you can't see it its under the view menu) Cheers JulieD "David Peterson" wrote in message link.net... I have a form based on a table. I can print a report on each record one at a time. If I print the report for ALL records, I get one report header and one report footer. How can I print reports for ALL records and get a report header/footer on each record's report? Right now I would have to select each record and print it. |
#3
|
|||
|
|||
Print a Report for each record in a table
Thanks, Tried that.
There are Report Totals in the header/footer that don't work when I do that. More suggestions? "JulieD" wrote in message ... Hi David move the information out of the report header & footer into the page header & footer (if you can't see it its under the view menu) Cheers JulieD "David Peterson" wrote in message link.net... I have a form based on a table. I can print a report on each record one at a time. If I print the report for ALL records, I get one report header and one report footer. How can I print reports for ALL records and get a report header/footer on each record's report? Right now I would have to select each record and print it. |
#4
|
|||
|
|||
Print a Report for each record in a table
Hi David
haven't tested this but what about placing a "sub-report" in the page footer section that contains the information that you would normally show in the report footer section (ie create a "totals" query and use that as the source for the page footer) -do the same for the header section if necessary. Cheers JulieD "David Peterson" wrote in message link.net... Thanks, Tried that. There are Report Totals in the header/footer that don't work when I do that. More suggestions? "JulieD" wrote in message ... Hi David move the information out of the report header & footer into the page header & footer (if you can't see it its under the view menu) Cheers JulieD "David Peterson" wrote in message link.net... I have a form based on a table. I can print a report on each record one at a time. If I print the report for ALL records, I get one report header and one report footer. How can I print reports for ALL records and get a report header/footer on each record's report? Right now I would have to select each record and print it. |
#5
|
|||
|
|||
Print a Report for each record in a table
David,
Check your expression for report totals. You should be able to write expressions for totals on the page header and footer to give you totals just for the page. Julie had the right idea to give you a report for each record. -- PC Datasheet Your Resource For Help With Access, Excel And Word Applications www.pcdatasheet.com "David Peterson" wrote in message link.net... Thanks, Tried that. There are Report Totals in the header/footer that don't work when I do that. More suggestions? "JulieD" wrote in message ... Hi David move the information out of the report header & footer into the page header & footer (if you can't see it its under the view menu) Cheers JulieD "David Peterson" wrote in message link.net... I have a form based on a table. I can print a report on each record one at a time. If I print the report for ALL records, I get one report header and one report footer. How can I print reports for ALL records and get a report header/footer on each record's report? Right now I would have to select each record and print it. |
#6
|
|||
|
|||
Print a Report for each record in a table
I tried. Most now work.
Need help getting page number correct. Should say page 1 of 3, page 2 of 3, page 3 of 3 on each report. Actually says page 1 of 180, page 2 of 180, page 3 of 180, then next report says page 4 of 180, page 5 of 180, page 6 of 180 (should say 1 of 3, 2 of 3, 3 of 3 each time) "David Peterson" wrote in message link.net... Thanks, Tried that. There are Report Totals in the header/footer that don't work when I do that. More suggestions? "JulieD" wrote in message ... Hi David move the information out of the report header & footer into the page header & footer (if you can't see it its under the view menu) Cheers JulieD "David Peterson" wrote in message link.net... I have a form based on a table. I can print a report on each record one at a time. If I print the report for ALL records, I get one report header and one report footer. How can I print reports for ALL records and get a report header/footer on each record's report? Right now I would have to select each record and print it. |
#7
|
|||
|
|||
Print a Report for each record in a table
a.. Group the report by RecordID
b.. Set the Group's ForceNewPage property to Before Section c.. In the Group Header Format event, write: [Page] = 1 -- PC Datasheet Your Resource For Help With Access, Excel And Word Applications www.pcdatasheet.com "David Peterson" wrote in message link.net... I tried. Most now work. Need help getting page number correct. Should say page 1 of 3, page 2 of 3, page 3 of 3 on each report. Actually says page 1 of 180, page 2 of 180, page 3 of 180, then next report says page 4 of 180, page 5 of 180, page 6 of 180 (should say 1 of 3, 2 of 3, 3 of 3 each time) "David Peterson" wrote in message link.net... Thanks, Tried that. There are Report Totals in the header/footer that don't work when I do that. More suggestions? "JulieD" wrote in message ... Hi David move the information out of the report header & footer into the page header & footer (if you can't see it its under the view menu) Cheers JulieD "David Peterson" wrote in message link.net... I have a form based on a table. I can print a report on each record one at a time. If I print the report for ALL records, I get one report header and one report footer. How can I print reports for ALL records and get a report header/footer on each record's report? Right now I would have to select each record and print it. |
#8
|
|||
|
|||
Print a Report for each record in a table
For page numbering, see
http://www.mvps.org/access/reports/rpt0013.htm. I have used this code successfully. With the code, everything above Private Sub etc. goes at the very top of the code window, in the Declarations section. If you just paste the code I think this will take care of itself, but I'm not sure. For group totals, I used a hidden text box in the report detail with its control source set to the field for which you need totals, and its Running Sum set to Over Group. In the group footer I referenced the control. I have by now lost track of the origin of some of the very helpful suggestions I have received while learning about this stuff, but I know that most of them came from this group. The two previous responders to your post are among those who have been especially helpful. If I am now in a position to contribute from time to time, it is due in large part to this group. -----Original Message----- I tried. Most now work. Need help getting page number correct. Should say page 1 of 3, page 2 of 3, page 3 of 3 on each report. Actually says page 1 of 180, page 2 of 180, page 3 of 180, then next report says page 4 of 180, page 5 of 180, page 6 of 180 (should say 1 of 3, 2 of 3, 3 of 3 each time) "David Peterson" wrote in message news:7j6Rc.14102 ... Thanks, Tried that. There are Report Totals in the header/footer that don't work when I do that. More suggestions? "JulieD" wrote in message ... Hi David move the information out of the report header & footer into the page header & footer (if you can't see it its under the view menu) Cheers JulieD "David Peterson" wrote in message news:Uz5Rc.14079 ... I have a form based on a table. I can print a report on each record one at a time. If I print the report for ALL records, I get one report header and one report footer. How can I print reports for ALL records and get a report header/footer on each record's report? Right now I would have to select each record and print it. . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Force Bound Access Subreport to Repeat X Times | Tom Rogers | Setting Up & Running Reports | 7 | July 29th, 2004 02:12 PM |
Complicated Databse w/many relationships | Søren | Database Design | 7 | July 13th, 2004 05:41 AM |
Newbie? Do I use Report or Query | John Egan | New Users | 11 | June 28th, 2004 08:31 PM |
save ~50,000 record table sorted from one million record table | Pete317 | Database Design | 3 | June 20th, 2004 04:52 AM |
COMPARE THE TWO TABLES | Stefanie | General Discussion | 0 | June 4th, 2004 04:36 PM |