Carolyn Johnson
cjlabs at worldnet.att.net
Mon Nov 10 13:33:37 CST 2008
Thanks to everyone who helped with this problem -- making use of the first pass worked. Carolyn Johnson ----- Original Message ----- From: "Jim Dettman" <jimdettman at verizon.net> To: "'Access Developers discussion and problem solving'" <accessd at databaseadvisors.com> Sent: Monday, November 10, 2008 9:35 AM Subject: Re: [AccessD] text box in page header > Carolyn, > > "Two-pass" reports are done simply by adding a text control (hidden or > not) that references the pages property. > > When you do this, you force Access to do two passes on a report. The > first is a "dry run" through the report so it can figure out what the last > page will be. The second is when it actually prints the report. > > It's on this first pass that you can store information in a table or > memory and then do all sorts of things on the second pass. In your case, > I'd make a table in the report's OnOpen event, which you can use to record > the EventType and the page it first appears on. > > You'd do that with code OnFormat event of the EventType header section. > You need to use OnFormat as OnPrint events are not fired on the first > pass. > You can tell when your in the first pass of a report by checking pages, > which will be 0. > > Then in the second pass in the Page header OnFormat or OnPrint event, you > can read the table to see what appears on the current page. > > You can do all sort of things with this technique; reset page numbers > over > groups, add a to/from for each page in the header or footer of the page > (telephone book style), build a table of contents or an index for the > report, tell what is coming on the next page or appeared on a previous > page, > etc. > > Here's a link to a MSKB article which shows the basic technique: > > http://support.microsoft.com/kb/131937 > > If you have any questions holler. > > Jim. > > > > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Carolyn Johnson > Sent: Saturday, November 08, 2008 6:18 PM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] text box in page header > > Using the header did not work. > > Can you explain how to do a two pass report? That seems to be the > solution > > but I've never done that before. > > Thanks > Carolyn > > > > ----- Original Message ----- > From: "Jim Dettman" <jimdettman at verizon.net> > To: "'Access Developers discussion and problem solving'" > <accessd at databaseadvisors.com> > Sent: Saturday, November 08, 2008 2:00 PM > Subject: Re: [AccessD] text box in page header > > >> Carolyn, >> >> Try setting the force new page property to none for the Event ID footer >> and Before section for the force new page property on the header. >> >> If that doesn't work, then you'll probably need to make it a two pass >> report. You'd pickup and store the info for each page on the first pass, >> then push it to unbound text controls on the second to show the correct >> info. >> >> Jim. >> >> -----Original Message----- >> From: accessd-bounces at databaseadvisors.com >> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Carolyn >> Johnson >> Sent: Friday, November 07, 2008 9:49 PM >> To: Access Developers discussion and problem solving >> Subject: Re: [AccessD] text box in page header >> >> The report is a catalog with 2 main groups of records - field name >> EventType. Each group then has several subgroups. I want the page >> header >> to show the value of EventType, along with the date. >> >> There is an EventType footer with the force new page property set to >> After >> Section. >> >> On the first page for the second EventType, the page header text box >> EventType still has the old value. It's not until the EventType header >> section that the value changes. >> >> If I put the controls I want to print on each page into the EventType >> header >> >> with RepeatSection = true, I get the desired effect -- the EventyType >> and >> Date print at the top of each page -- EXCEPT on the page where the new >> group starts, the text boxes print twice, the first time with the old >> values >> >> and the second time with the new group's values. >> >> >> Thanks >> Carolyn Johnson >> >> >> >> ----- Original Message ----- >> From: "Susan Harkins" <ssharkins at gmail.com> >> To: "Access Developers discussion and problem solving" >> <accessd at databaseadvisors.com> >> Sent: Friday, November 07, 2008 8:39 PM >> Subject: Re: [AccessD] text box in page header >> >> >>> Is there just one group per page -- you mentioned wanting it in the >>> header -- do you mean the page header or the group header? >>> >>> Susan H. >>> >>> >>>> It comes from a value in the group. >>>> >>>> Carolyn Johnson >>>> >>>>> Does the header value come from a value in the group or are you just >>>>> sequentially numbering them? >>>>> >>>>>> Access2003, WinXP >>>>>> >>>>>> I have a text box in the page header of a report that changes values >>>>>> as >>>>>> the >>>>>> records move from one group to another. This text box on the first >>>>>> page >>>>>> of >>>>>> "group 2" still has the value for "group 1". Is there a way to get >>>>>> the >>>>>> correct value for a new group level in this text box, or do I have to >>>>>> move >>>>>> text box to the group header section? >>>>> >>>>> -- >>>>> AccessD mailing list >>>>> AccessD at databaseadvisors.com >>>>> http://databaseadvisors.com/mailman/listinfo/accessd >>>>> Website: http://www.databaseadvisors.com >>>> >>>> -- >>>> AccessD mailing list >>>> AccessD at databaseadvisors.com >>>> http://databaseadvisors.com/mailman/listinfo/accessd >>>> Website: http://www.databaseadvisors.com >>> >>> -- >>> AccessD mailing list >>> AccessD at databaseadvisors.com >>> http://databaseadvisors.com/mailman/listinfo/accessd >>> Website: http://www.databaseadvisors.com >> >> -- >> AccessD mailing list >> AccessD at databaseadvisors.com >> http://databaseadvisors.com/mailman/listinfo/accessd >> Website: http://www.databaseadvisors.com >> >> -- >> AccessD mailing list >> AccessD at databaseadvisors.com >> http://databaseadvisors.com/mailman/listinfo/accessd >> Website: http://www.databaseadvisors.com > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com