Multiple Page reports with repeating Header errors

[Matt P.]

Thank you for taking the time to read this.
How do I carry a header past the first page of a report
that is more than a page long. I have figured that if I
move the information from the Report Header to the Page
Header the information will carry over to the pages that
follow.
That was nice but I am having a #NAME? Error where I have
a text box with a formula in it, that corresponds to a
certain query. Depending on the query the value/output of
the text box changes. What I do not understand is that
the correct output is diplayed in the header of the first
page but the #NAME? error is displayed for every following
page. Just a note: There are labels that carry to
following pages with no problems, it is just the text box
that I am having trouble with.
The header is in the form:
Label: Formula
e.g. (Date(=NOW())which would output as Date:7/28/2004
This displays absolutely fine on the first page but on the
following pages it displays like this:
Date:#NAME?.
Please respond with any suggestions. Once again thank you
for your help.

 

[Roger Carlson]

For some reason I've never figured out, Access does not allow formulas in
text boxes in page headers and footers. Try using the Group Header and keep
the groups together. Then you can use the HasContinued property of the
Group Header to display a control if the group continues on to a new page.

On my website (see sig below) is a small sample database called
"HasContinued.mdb" which illustrates two methods for using this property.

 

[Matt P.]

Thank you.

-----Original Message-----
For some reason I've never figured out, Access does not allow formulas in
text boxes in page headers and footers. Try using the Group Header and keep
the groups together. Then you can use the HasContinued property of the
Group Header to display a control if the group continues on to a new page.

On my website (see sig below) is a small sample database called
"HasContinued.mdb" which illustrates two methods for using this property.

--
--Roger Carlson
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org




.

 

[Marshall Barton]

For some reason I've never figured out, Access does not allow formulas in
text boxes in page headers and footers.

Roger, I've never had an issue like this and I use formulas
in page header/footers all the time.

Do you have a concrete example that causes a problem?

 

[Marshall Barton]

How do I carry a header past the first page of a report
that is more than a page long. I have figured that if I
move the information from the Report Header to the Page
Header the information will carry over to the pages that
follow.
That was nice but I am having a #NAME? Error where I have
a text box with a formula in it, that corresponds to a
certain query. Depending on the query the value/output of
the text box changes. What I do not understand is that
the correct output is diplayed in the header of the first
page but the #NAME? error is displayed for every following
page. Just a note: There are labels that carry to
following pages with no problems, it is just the text box
that I am having trouble with.
The header is in the form:
Label: Formula
e.g. (Date(=NOW())which would output as Date:7/28/2004
This displays absolutely fine on the first page but on the
following pages it displays like this:
Date:#NAME?.

I can't see what might be causing that problem. Are you
sure that the text box's expression is =Now()

If so, check your References to make sure that they all are
properly resolved.

 

[Roger Carlson]

That's what I love about this place. As soon as I shoot my mouth off
without thinking, someone is bound to call me on it. Thank you.

I guess what I was specifically referring to was using aggregate functions
in a Page footer. Like: =Sum([Myfield]) or =Count([MyField]). These will
not work in the Page footer, but will work in group and report footers.

My apologies for leading anyone astray.

 

[Marshall Barton]

That's what I love about this place. As soon as I shoot my mouth off
without thinking, someone is bound to call me on it. Thank you.

I guess what I was specifically referring to was using aggregate functions
in a Page footer. Like: =Sum([Myfield]) or =Count([MyField]). These will
not work in the Page footer, but will work in group and report footers.

My apologies for leading anyone astray.

Ah, I understand.

You be sure to call me on my mistatements too ;-)