By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
458,192 Members | 1,714 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 458,192 IT Pros & Developers. It's quick & easy.

Change Report Header for Different Sections

P: n/a
I've tried to be clear, but this still seems overly complex to me, but
here goes:

I have a report in front of an aggregate query. I have a single
subreport based on the same query for both a month/year group and for
grand totals (linked on month/year) .

Instead of the name of the program and the month/year, I would like:

- a label on the report header to read "Monthly Summary" with the month
& year when the subreport is printing for the footer of the month/year
group and

- a label on the report header to read "Overall Summary" when the
subreport is printing for the report footer.

I guess what I'm asking is how do I "sense" what report section I'm
viewing/printing a page from?

I'm using Access 2000.

TIA

Neill

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Look at the Format event of the PageHeaderSection and PageFooterSection in
Help and in this newsgroup.

Darryl Kerkeslager
"neill dumont" <ne**********@gmail.com> wrote:
I have a report in front of an aggregate query. I have a single
subreport based on the same query for both a month/year group and for
grand totals (linked on month/year) .

Instead of the name of the program and the month/year, I would like:

- a label on the report header to read "Monthly Summary" with the month
& year when the subreport is printing for the footer of the month/year
group and

- a label on the report header to read "Overall Summary" when the
subreport is printing for the report footer.

I guess what I'm asking is how do I "sense" what report section I'm
viewing/printing a page from?

Nov 13 '05 #2

P: n/a
OK, I did that. There were two messages that showed up on Google
Groups for this group: the response to my original post and another one
that had nothing to do with subreports. Help made no mention of doing
this for a subreport and Googling brought up a lot of stuff on how to
do totals in page footers. None of them help me.

I don't know how to do this. Would someone please take the time to
explain, in words of one syllable or less, how I can do this?

I tried the following in the DateFooter section that runs the
subreport, but no luck. The format event for DateFooter will fire, but
no change is made to the pageheader. Combo122 and lblMonthly are both
in the Parent report :

Private Sub DateFooter_Format(Cancel As Integer, FormatCount As
Integer)

Me.Combo122.Visible = False
Me.lblMonthly.Visible = True

End Sub

TIA

Neill
Look at the Format event of the PageHeaderSection and PageFooterSection in Help and in this newsgroup.

Darryl Kerkeslager

"neill dumont" <neill.dum...@gmail.com> wrote:

I have a report in front of an aggregate query. I have a single
subreport based on the same query for both a month/year group and for grand totals (linked on month/year) .

Instead of the name of the program and the month/year, I would like:

- a label on the report header to read "Monthly Summary" with the month & year when the subreport is printing for the footer of the month/year group and

- a label on the report header to read "Overall Summary" when the
subreport is printing for the report footer.

I guess what I'm asking is how do I "sense" what report section I'm
viewing/printing a page from?


Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.