No header in Group Footer

[Guest]

I thought I resolved this issue but it came back to haunt me.

My question is:
How do I get my group footer to print without the group header?
The way my report works:
My group header is [jobnum]
I enter a date range and my report produces a payroll report for every job
worked
and in the job footer after each job I print a cover sheet with info about
that job.
Then the second job prints, etc.
Help!

 

[Duane Hookom]

You can set the height of your group header to 0".

 

[Guest]

Sorry Duane

It's my page header that I'm trying to suppress in my group footer. Does
that change your answer? I need the page header for every page except the
last and I need the page header to resume when it goes to the next group.

You can set the height of your group header to 0".

--
Duane Hookom
MS Access MVP
--

I thought I resolved this issue but it came back to haunt me.

My question is:
How do I get my group footer to print without the group header?
The way my report works:
My group header is [jobnum]
I enter a date range and my report produces a payroll report for every job
worked
and in the job footer after each job I print a cover sheet with info about
that job.
Then the second job prints, etc.
Help!

 

[Duane Hookom]

You can hide the page header on the last page by using code in its On Format
event. This assumes you have a text box in your report bound to [Pages].

Private Sub PageHeaderSection_Format(Cancel As Integer, FormatCount As
Integer)
Cancel = (Me.Page = Me.Pages)
End Sub

--
Duane Hookom
MS Access MVP
--

Sorry Duane

It's my page header that I'm trying to suppress in my group footer. Does
that change your answer? I need the page header for every page except the
last and I need the page header to resume when it goes to the next group.

You can set the height of your group header to 0".

--
Duane Hookom
MS Access MVP
--

I thought I resolved this issue but it came back to haunt me.

My question is:
How do I get my group footer to print without the group header?
The way my report works:
My group header is [jobnum]
I enter a date range and my report produces a payroll report for every
job
worked
and in the job footer after each job I print a cover sheet with info
about
that job.
Then the second job prints, etc.
Help!

 

[Guest]

I'm lost.
I assume this is an event procedure. I went to the on Format event in the
page header. My group footer is named [jobno] and I substitued the word
pages for the word jobno. Is this correct? Nothing happened. I don't
really know what I'm doing here. (I don't understand coding.) Don't give
up on me though ameteur I am.

You can hide the page header on the last page by using code in its On Format
event. This assumes you have a text box in your report bound to [Pages].

Private Sub PageHeaderSection_Format(Cancel As Integer, FormatCount As
Integer)
Cancel = (Me.Page = Me.Pages)
End Sub

--
Duane Hookom
MS Access MVP
--

Sorry Duane

It's my page header that I'm trying to suppress in my group footer. Does
that change your answer? I need the page header for every page except the
last and I need the page header to resume when it goes to the next group.

You can set the height of your group header to 0".

--
Duane Hookom
MS Access MVP
--

I thought I resolved this issue but it came back to haunt me.

My question is:
How do I get my group footer to print without the group header?
The way my report works:
My group header is [jobnum]
I enter a date range and my report produces a payroll report for every
job
worked
and in the job footer after each job I print a cover sheet with info
about
that job.
Then the second job prints, etc.
Help!

 

[Guest]

I played around and got what I needed by using
cancel = (me.page=me.pageheader)
Thanks

I'm lost.
I assume this is an event procedure. I went to the on Format event in the
page header. My group footer is named [jobno] and I substitued the word
pages for the word jobno. Is this correct? Nothing happened. I don't
really know what I'm doing here. (I don't understand coding.) Don't give
up on me though ameteur I am.

You can hide the page header on the last page by using code in its On Format
event. This assumes you have a text box in your report bound to [Pages].

Private Sub PageHeaderSection_Format(Cancel As Integer, FormatCount As
Integer)
Cancel = (Me.Page = Me.Pages)
End Sub

--
Duane Hookom
MS Access MVP
--

Sorry Duane

It's my page header that I'm trying to suppress in my group footer. Does
that change your answer? I need the page header for every page except the
last and I need the page header to resume when it goes to the next group.

:

You can set the height of your group header to 0".

--
Duane Hookom
MS Access MVP
--

I thought I resolved this issue but it came back to haunt me.

My question is:
How do I get my group footer to print without the group header?
The way my report works:
My group header is [jobnum]
I enter a date range and my report produces a payroll report for every
job
worked
and in the job footer after each job I print a cover sheet with info
about
that job.
Then the second job prints, etc.
Help!

 

[Duane Hookom]

I'm not sure why that would work. I don't know why you changed the code that
I had provided. I tested it in a sample report and it correctly hid the page
header on the last page of the report. I only needed to have a text box on
the report that was bound to [Pages].

--
Duane Hookom
MS Access MVP
--

I played around and got what I needed by using
cancel = (me.page=me.pageheader)
Thanks

I'm lost.
I assume this is an event procedure. I went to the on Format event in
the
page header. My group footer is named [jobno] and I substitued the word
pages for the word jobno. Is this correct? Nothing happened. I don't
really know what I'm doing here. (I don't understand coding.) Don't
give
up on me though ameteur I am.

You can hide the page header on the last page by using code in its On
Format
event. This assumes you have a text box in your report bound to
[Pages].

Private Sub PageHeaderSection_Format(Cancel As Integer, FormatCount As
Integer)
Cancel = (Me.Page = Me.Pages)
End Sub

--
Duane Hookom
MS Access MVP
--

Sorry Duane

It's my page header that I'm trying to suppress in my group footer.
Does
that change your answer? I need the page header for every page
except the
last and I need the page header to resume when it goes to the next
group.

:

You can set the height of your group header to 0".

--
Duane Hookom
MS Access MVP
--

I thought I resolved this issue but it came back to haunt me.

My question is:
How do I get my group footer to print without the group header?
The way my report works:
My group header is [jobnum]
I enter a date range and my report produces a payroll report for
every
job
worked
and in the job footer after each job I print a cover sheet with
info
about
that job.
Then the second job prints, etc.
Help!

 

[Rick Brandt]

I'm not sure why that would work. I don't know why you changed the
code that I had provided. I tested it in a sample report and it
correctly hid the page header on the last page of the report. I only
needed to have a text box on the report that was bound to [Pages].

Couldn't one just set the PageHeader property of the report to...

Not with Rpt Ftr

 

[Duane Hookom]

Probably a great solution. My head is still back in earlier versions of
Access that didn't include this functionality.

--
Duane Hookom
MS Access MVP
--

I'm not sure why that would work. I don't know why you changed the
code that I had provided. I tested it in a sample report and it
correctly hid the page header on the last page of the report. I only
needed to have a text box on the report that was bound to [Pages].

Couldn't one just set the PageHeader property of the report to...

Not with Rpt Ftr

 

[Guest]

The problem was not in the report footer but in the group footer. My report
doesn't have (or need) a report header or footer. I'm assuming I'm using the
correct terms.
Duane when I used your code I continued to get the page header on each sheet
of the group footer. After printing the detail for a group, I force a page
so that I can put information about that group only, on a clean cover sheet.
The report continues with the next group until all groups within a date
parameter are printed.
I only have a small amount of data at present and I'll have to see if the
solution I've used will continue to work.
Thanks again.

Probably a great solution. My head is still back in earlier versions of
Access that didn't include this functionality.

--
Duane Hookom
MS Access MVP
--

I'm not sure why that would work. I don't know why you changed the
code that I had provided. I tested it in a sample report and it
correctly hid the page header on the last page of the report. I only
needed to have a text box on the report that was bound to [Pages].

Couldn't one just set the PageHeader property of the report to...

Not with Rpt Ftr

 

[Marshall Barton]

You can hide the page header on the last page by using code in its On Format
event. This assumes you have a text box in your report bound to [Pages].

Private Sub PageHeaderSection_Format(Cancel As Integer, FormatCount As
Integer)
Cancel = (Me.Page = Me.Pages)
End Sub

Those are good answers, but the question is about the group
footer, not the report footer.

Presumably, the group footer has it's ForceNewPage property
set to Before Section, so it's possible to use the last
detail in a group to turn off the page header.

This can be done by using the group header section to set
things up. Add a text box named txtDtlTotal and set its
control source expression to =Count(*).

Next, add an invisible text box named txtDtlCnt to the
detail section. Set its control source expression to =1 and
RunningSum property to Over Group. Then add a line of code
to the Detail section Format event:
Me.Section(3).Visible = (txtDtlCnt = txtDtlTotal)

Finally, use the group footer section's Format event to turn
the page header back on for the next group:
Me.Section(3).Visible = True

 

[Duane Hookom]

It's not clear what you have for grouping sorting etc and what you want.
Your statement "page header on each sheet of the group footer" only confuses
me.

--
Duane Hookom
MS Access MVP
--

The problem was not in the report footer but in the group footer. My
report
doesn't have (or need) a report header or footer. I'm assuming I'm using
the
correct terms.
Duane when I used your code I continued to get the page header on each
sheet
of the group footer. After printing the detail for a group, I force a
page
so that I can put information about that group only, on a clean cover
sheet.
The report continues with the next group until all groups within a date
parameter are printed.
I only have a small amount of data at present and I'll have to see if the
solution I've used will continue to work.
Thanks again.

Probably a great solution. My head is still back in earlier versions of
Access that didn't include this functionality.

--
Duane Hookom
MS Access MVP
--

Duane Hookom wrote:
I'm not sure why that would work. I don't know why you changed the
code that I had provided. I tested it in a sample report and it
correctly hid the page header on the last page of the report. I only
needed to have a text box on the report that was bound to [Pages].

Couldn't one just set the PageHeader property of the report to...

Not with Rpt Ftr