[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