Hide Main Report Page Footer on Subreport pages

Marshall, Thanks for your help but that didn't work. I am getting an macro
error message. Not sure why but can we try something else.

Thanks for your help in advance.
Judy

"Marshall Barton" wrote:

> JudyT wrote:
>
> >Okay. I have a report which contains a subreport in a group footer section,
> >so that the Main Report is like a summary and then there is a page break in
> >the group footer section then the subreport starts on the next page and
> >contains details. Then the you have another main report page, then more
> >detail subreport pages, etc.
> >
> >My problem is I have a Page Footer on my Main Report and I only want it to
> >show on the Main Report "summary pages" not the Subreport "detail pages". I
> >need the info as a page footer so it puts it at the bottom of the page.
>
>
> The subreport's Open event procedure can hide the main
> report's page footer:
> Parent.Section(4).Visible = False
>
> You can use the main report group header section to make it
> visible again:
> Me.Section(4).Visible = True
>
> --
> Marsh
> MVP [MS Access]
>

Couple of things to try:

1) Jump up and down and scream at the computer

2) Explain what "doesn't work" means in terms of what
actually happened along with the exact error message.

When you mentioned a "macro error" I get worried, because
what I posted has nothing to do with macros.
--
Marsh
MVP [MS Access]


JudyT wrote:

>Marshall, Thanks for your help but that didn't work. I am getting an macro
>error message. Not sure why but can we try something else.
>
>"Marshall Barton" wrote:
>
>> JudyT wrote:
>>
>> >Okay. I have a report which contains a subreport in a group footer section,
>> >so that the Main Report is like a summary and then there is a page break in
>> >the group footer section then the subreport starts on the next page and
>> >contains details. Then the you have another main report page, then more
>> >detail subreport pages, etc.
>> >
>> >My problem is I have a Page Footer on my Main Report and I only want it to
>> >show on the Main Report "summary pages" not the Subreport "detail pages". I
>> >need the info as a page footer so it puts it at the bottom of the page.
>>
>>
>> The subreport's Open event procedure can hide the main
>> report's page footer:
>> Parent.Section(4).Visible = False
>>
>> You can use the main report group header section to make it
>> visible again:
>> Me.Section(4).Visible = True

Marsh,

#1 didn't work, so I will give you the info needed for #2.

I typed:

1) Parent.Section(4).Visible = False in the Subreport's On Open... Event

2) Me.Section(4).Visible = True in the Main Report's Group Header (which is
called CC Header in my report) On Print... Event

I chose the On Print Event Procedure on the Main Report because I was not
really sure where to put it - I hope this was the correct place.

When I try to run the report I recevie the following two errors:

Microsoft Office Access can't find the macro 'Parent'
The macro (or its macro group) doesn't exist, or the macro is new but hasn't
been saved.
Note that when you enter the macrogroupname.macroname syntax in an argument,
you must specify the name the macro's macro group was last saved under.

Microsoft Office Access can't find the macro 'Me'
The macro (or its macro group) doesn't exist, or the macro is new but hasn't
been saved.
Note that when you enter the macrogroupname.macroname syntax in an argument,
you must specify the name the macro's macro group was last saved under.

I am then taken back to the report's design view.

Also, I'm not sure if this is relevant or not but I am running this databse
though a Citrix environment.

Thanks for your help,
Judy


"Marshall Barton" wrote:

> Couple of things to try:
>
> 1) Jump up and down and scream at the computer
>
> 2) Explain what "doesn't work" means in terms of what
> actually happened along with the exact error message.
>
> When you mentioned a "macro error" I get worried, because
> what I posted has nothing to do with macros.
> --
> Marsh
> MVP [MS Access]
>
>
> JudyT wrote:
>
> >Marshall, Thanks for your help but that didn't work. I am getting an macro
> >error message. Not sure why but can we try something else.
> >
> >"Marshall Barton" wrote:
> >
> >> JudyT wrote:
> >>
> >> >Okay. I have a report which contains a subreport in a group footer section,
> >> >so that the Main Report is like a summary and then there is a page break in
> >> >the group footer section then the subreport starts on the next page and
> >> >contains details. Then the you have another main report page, then more
> >> >detail subreport pages, etc.
> >> >
> >> >My problem is I have a Page Footer on my Main Report and I only want it to
> >> >show on the Main Report "summary pages" not the Subreport "detail pages". I
> >> >need the info as a page footer so it puts it at the bottom of the page.
> >>
> >>
> >> The subreport's Open event procedure can hide the main
> >> report's page footer:
> >> Parent.Section(4).Visible = False
> >>
> >> You can use the main report group header section to make it
> >> visible again:
> >> Me.Section(4).Visible = True
>

JudyT wrote:
>#1 didn't work, so I will give you the info needed for #2.

Might have been worth a try even if it just vented some
frustration

>
>I typed:
>
>1) Parent.Section(4).Visible = False in the Subreport's On Open... Event
>
>2) Me.Section(4).Visible = True in the Main Report's Group Header (which is
>called CC Header in my report) On Print... Event
>
>I chose the On Print Event Procedure on the Main Report because I was not
>really sure where to put it - I hope this was the correct place.


Ah Ha!

You typed the line of VBA code in the OnPrint property when
it needs to be in the Print event ***procedure***

To get to the event procedure, select
[Event Procedure]
in the OnPrint property.

Then click on the builder button [...] at the far right of
the property. That should take you to the event procedure
where you can enter the line of code between the Sub and End
Sub lines.

--
Marsh
MVP [MS Access]

Wow, it would really help if I knew what I was doing, huh!

Well, moving the two lines of code into the event procedure did get rid of
the error messages, and now the report runs; however, it's still not doing
what I need it to.

It now doesn't print the footer on any on the pages including the Main
Report. Am I putting the Me.Section(4).Visible = True Event Procedure into
the wrong place maybe?

I tried moving it to the Report Header's On Print instead of the Group
Header's On Print, but this did not work.

Thank you for you help, I feel like we are gettingreally close now.

"Marshall Barton" wrote:

> JudyT wrote:
> >#1 didn't work, so I will give you the info needed for #2.
>
> Might have been worth a try even if it just vented some
> frustration
>
> >
> >I typed:
> >
> >1) Parent.Section(4).Visible = False in the Subreport's On Open... Event
> >
> >2) Me.Section(4).Visible = True in the Main Report's Group Header (which is
> >called CC Header in my report) On Print... Event
> >
> >I chose the On Print Event Procedure on the Main Report because I was not
> >really sure where to put it - I hope this was the correct place.
>
>
> Ah Ha!
>
> You typed the line of VBA code in the OnPrint property when
> it needs to be in the Print event ***procedure***
>
> To get to the event procedure, select
> [Event Procedure]
> in the OnPrint property.
>
> Then click on the builder button [...] at the far right of
> the property. That should take you to the event procedure
> where you can enter the line of code between the Sub and End
> Sub lines.
>
> --
> Marsh
> MVP [MS Access]
>

JudyT wrote:
>Well, moving the two lines of code into the event procedure did get rid of
>the error messages, and now the report runs; however, it's still not doing
>what I need it to.
>
>It now doesn't print the footer on any on the pages including the Main
>Report. Am I putting the Me.Section(4).Visible = True Event Procedure into
>the wrong place maybe?
>
>I tried moving it to the Report Header's On Print instead of the Group
>Header's On Print, but this did not work.

You might(?) need the line:
Me.Section(4).Visible = True
In the Report Header's Format (or Print) event procedure
too. However, I would expect that putting it just in the
group header's Format (or Print) event procedure would be
sufficient.

Try the Format event instead of the Print event.

If it still doesn't worl, post back with a Copy/Paste of the
code you have.
--
Marsh
MVP [MS Access]


>> >
>> >I typed:
>> >
>> >1) Parent.Section(4).Visible = False in the Subreport's On Open... Event
>> >
>> >2) Me.Section(4).Visible = True in the Main Report's Group Header (which is
>> >called CC Header in my report) On Print... Event
>> >
>> >I chose the On Print Event Procedure on the Main Report because I was not