A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Report - Don't print the page footer on the last page



 
 
Thread Tools Display Modes
  #1  
Old May 19th, 2010, 06:36 PM posted to microsoft.public.access.reports
Dwade
external usenet poster
 
Posts: 17
Default Report - Don't print the page footer on the last page

When I print a report I don't want the page footer to print at the end of the
report
I only want the report footer to print

The page header must print on each page.

The report is for a donation report. Grouped off donation Id, can have any
number of items on each report 1 to xxx,xxx,x though the maxiumum so far is
25 items. which rolls the report to 2 pages.

The report footer contains a signature block and also the same line as the
page footer.
Page footer (="Print Date: "&Now() ="page" & [Page]&" of "&[Pages]
Ads
  #2  
Old May 19th, 2010, 07:16 PM posted to microsoft.public.access.reports
Marshall Barton
external usenet poster
 
Posts: 5,361
Default Report - Don't print the page footer on the last page

Dwade wrote:

When I print a report I don't want the page footer to print at the end of the
report
I only want the report footer to print

The page header must print on each page.

The report is for a donation report. Grouped off donation Id, can have any
number of items on each report 1 to xxx,xxx,x though the maxiumum so far is
25 items. which rolls the report to 2 pages.

The report footer contains a signature block and also the same line as the
page footer.
Page footer (="Print Date: "&Now() ="page" & [Page]&" of "&[Pages]



To reclaim the space used by the page footer, you need to
make it invisible no later than the page header section's
Format or Print event:

Me.Section(4).Visible = (Me.Page Me.Pages)

BUT, if things line up just the wrong way where the details
an report footer will fit on the last page if there is no
footer and not fit if there is a footer, you can get strange
things like Page 2 of 3 or Page 3 of 2 on the last page or
the footer all by itself on the last page.

If you do not care about reclaming the page footer space,
then just use a line of code in the page footer's Format or
Print event:
Cancel = (Me.Page = Me.Pages)

--
Marsh
MVP [MS Access]
  #3  
Old May 19th, 2010, 08:05 PM posted to microsoft.public.access.reports
Dwade
external usenet poster
 
Posts: 17
Default Report - Don't print the page footer on the last page

I want the report footer to print without printing the page footer on the
final page. Any other page prior the footer can and should print. I just want
to suppress the page footer on the final page.

The report footer contains signature block.

"Marshall Barton" wrote:

Dwade wrote:

When I print a report I don't want the page footer to print at the end of the
report
I only want the report footer to print

The page header must print on each page.

The report is for a donation report. Grouped off donation Id, can have any
number of items on each report 1 to xxx,xxx,x though the maxiumum so far is
25 items. which rolls the report to 2 pages.

The report footer contains a signature block and also the same line as the
page footer.
Page footer (="Print Date: "&Now() ="page" & [Page]&" of "&[Pages]



To reclaim the space used by the page footer, you need to
make it invisible no later than the page header section's
Format or Print event:

Me.Section(4).Visible = (Me.Page Me.Pages)

BUT, if things line up just the wrong way where the details
an report footer will fit on the last page if there is no
footer and not fit if there is a footer, you can get strange
things like Page 2 of 3 or Page 3 of 2 on the last page or
the footer all by itself on the last page.

If you do not care about reclaming the page footer space,
then just use a line of code in the page footer's Format or
Print event:
Cancel = (Me.Page = Me.Pages)

--
Marsh
MVP [MS Access]
.

  #4  
Old May 19th, 2010, 09:57 PM posted to microsoft.public.access.reports
Marshall Barton
external usenet poster
 
Posts: 5,361
Default Report - Don't print the page footer on the last page

Right. Did you try my last suggestion?
--
Marsh
MVP [MS Access]


Dwade wrote:
I want the report footer to print without printing the page footer on the
final page. Any other page prior the footer can and should print. I just want
to suppress the page footer on the final page.

The report footer contains signature block.

"Marshall Barton" wrote:

Dwade wrote:

When I print a report I don't want the page footer to print at the end of the
report
I only want the report footer to print

The page header must print on each page.

The report is for a donation report. Grouped off donation Id, can have any
number of items on each report 1 to xxx,xxx,x though the maxiumum so far is
25 items. which rolls the report to 2 pages.

The report footer contains a signature block and also the same line as the
page footer.
Page footer (="Print Date: "&Now() ="page" & [Page]&" of "&[Pages]



To reclaim the space used by the page footer, you need to
make it invisible no later than the page header section's
Format or Print event:

Me.Section(4).Visible = (Me.Page Me.Pages)

BUT, if things line up just the wrong way where the details
an report footer will fit on the last page if there is no
footer and not fit if there is a footer, you can get strange
things like Page 2 of 3 or Page 3 of 2 on the last page or
the footer all by itself on the last page.

If you do not care about reclaming the page footer space,
then just use a line of code in the page footer's Format or
Print event:
Cancel = (Me.Page = Me.Pages)

  #5  
Old May 20th, 2010, 12:06 AM posted to microsoft.public.access.reports
Dwade
external usenet poster
 
Posts: 17
Default Report - Don't print the page footer on the last page

Cancel = (Me.Page = Me.Pages) worked fine

the other one

Me.Section(4).Visible = (Me.Page Me.Pages)

for some reason won't work (probably a typo or something simple on my part)

"Marshall Barton" wrote:

Right. Did you try my last suggestion?
--
Marsh
MVP [MS Access]


Dwade wrote:
I want the report footer to print without printing the page footer on the
final page. Any other page prior the footer can and should print. I just want
to suppress the page footer on the final page.

The report footer contains signature block.

"Marshall Barton" wrote:

Dwade wrote:

When I print a report I don't want the page footer to print at the end of the
report
I only want the report footer to print

The page header must print on each page.

The report is for a donation report. Grouped off donation Id, can have any
number of items on each report 1 to xxx,xxx,x though the maxiumum so far is
25 items. which rolls the report to 2 pages.

The report footer contains a signature block and also the same line as the
page footer.
Page footer (="Print Date: "&Now() ="page" & [Page]&" of "&[Pages]


To reclaim the space used by the page footer, you need to
make it invisible no later than the page header section's
Format or Print event:

Me.Section(4).Visible = (Me.Page Me.Pages)

BUT, if things line up just the wrong way where the details
an report footer will fit on the last page if there is no
footer and not fit if there is a footer, you can get strange
things like Page 2 of 3 or Page 3 of 2 on the last page or
the footer all by itself on the last page.

If you do not care about reclaming the page footer space,
then just use a line of code in the page footer's Format or
Print event:
Cancel = (Me.Page = Me.Pages)

.

  #6  
Old May 20th, 2010, 01:11 AM posted to microsoft.public.access.reports
fredg
external usenet poster
 
Posts: 4,386
Default Report - Don't print the page footer on the last page

On Wed, 19 May 2010 10:36:01 -0700, Dwade wrote:

When I print a report I don't want the page footer to print at the end of the
report
I only want the report footer to print

The page header must print on each page.

The report is for a donation report. Grouped off donation Id, can have any
number of items on each report 1 to xxx,xxx,x though the maxiumum so far is
25 items. which rolls the report to 2 pages.

The report footer contains a signature block and also the same line as the
page footer.
Page footer (="Print Date: "&Now() ="page" & [Page]&" of "&[Pages]


Set the Report's Page Footer property to
Not with Rpt Ftr
You'll find it on the Report property sheet's Format tab.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
  #7  
Old May 20th, 2010, 03:27 AM posted to microsoft.public.access.reports
Marshall Barton
external usenet poster
 
Posts: 5,361
Default Report - Don't print the page footer on the last page

fredg wrote:

On Wed, 19 May 2010 10:36:01 -0700, Dwade wrote:

When I print a report I don't want the page footer to print at the end of the
report
I only want the report footer to print

The page header must print on each page.

The report is for a donation report. Grouped off donation Id, can have any
number of items on each report 1 to xxx,xxx,x though the maxiumum so far is
25 items. which rolls the report to 2 pages.

The report footer contains a signature block and also the same line as the
page footer.
Page footer (="Print Date: "&Now() ="page" & [Page]&" of "&[Pages]


Set the Report's Page Footer property to
Not with Rpt Ftr
You'll find it on the Report property sheet's Format tab.



That's an odd place for them to hide a property that
simplifies what used to be a nasty problem ;-)

--
Marsh
MVP [MS Access]
  #8  
Old May 20th, 2010, 05:11 PM posted to microsoft.public.access.reports
Dwade
external usenet poster
 
Posts: 17
Default Report - Don't print the page footer on the last page

........ "You'll find it on the Report property sheet's Format tab."

Where do I find that? I can't find where to set the page footer propery. I
can go to the property sheet for the page footer but is not there. ??? I'm
confused.

"fredg" wrote:

On Wed, 19 May 2010 10:36:01 -0700, Dwade wrote:

When I print a report I don't want the page footer to print at the end of the
report
I only want the report footer to print

The page header must print on each page.

The report is for a donation report. Grouped off donation Id, can have any
number of items on each report 1 to xxx,xxx,x though the maxiumum so far is
25 items. which rolls the report to 2 pages.

The report footer contains a signature block and also the same line as the
page footer.
Page footer (="Print Date: "&Now() ="page" & [Page]&" of "&[Pages]


Set the Report's Page Footer property to
Not with Rpt Ftr
You'll find it on the Report property sheet's Format tab.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
.

  #9  
Old May 20th, 2010, 05:45 PM posted to microsoft.public.access.reports
John Spencer
external usenet poster
 
Posts: 7,815
Default Report - Don't print the page footer on the last page

It's in the REPORT's properties, not in the footer's properties.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

Dwade wrote:
....... "You'll find it on the Report property sheet's Format tab."

Where do I find that? I can't find where to set the page footer propery. I
can go to the property sheet for the page footer but is not there. ??? I'm
confused.

"fredg" wrote:

On Wed, 19 May 2010 10:36:01 -0700, Dwade wrote:

When I print a report I don't want the page footer to print at the end of the
report
I only want the report footer to print

The page header must print on each page.

The report is for a donation report. Grouped off donation Id, can have any
number of items on each report 1 to xxx,xxx,x though the maxiumum so far is
25 items. which rolls the report to 2 pages.

The report footer contains a signature block and also the same line as the
page footer.
Page footer (="Print Date: "&Now() ="page" & [Page]&" of "&[Pages]

Set the Report's Page Footer property to
Not with Rpt Ftr
You'll find it on the Report property sheet's Format tab.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
.

  #10  
Old May 20th, 2010, 11:56 PM posted to microsoft.public.access.reports
Dwade
external usenet poster
 
Posts: 17
Default Report - Don't print the page footer on the last page

Duhhhh!!!.

Thanks to all the help I did find several ways to get the job done. Report
Footer unfortunately doesn't print at the bottom of the page.

Page footer worked but I didn't want all the information to appear on every
page.

I placed the objects (information and signature blocks) that I needed to
appear only on the last page in the page footer and set visible property to
NO. I then set the event procedure

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


If [Page] = [Pages] Then
[SignatureBox].Visible = True
[AccepteeSign].Visible = True
[SignDateBox].Visible = True
[SignDate].Visible = True
'enter all the invisible items that you want to turn visible
[InfoBox].Visible = True
[InfoLabelBox1].Visible = True
[InfoLabelBox2].Visible = True

End If

End Sub

While this did add some white space to the page footer, approx 1.5" it was
preferable to having the report footer printing one line under the detail
section.

I find that not being able to specify where on a page I want a section to
start printing (or end) is a bit of a headache. It definietly isn't straight
forward and easy.

Using an Event Procedure to make objects/fields visible in the page footer
did work.

"John Spencer" wrote:

It's in the REPORT's properties, not in the footer's properties.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

Dwade wrote:
....... "You'll find it on the Report property sheet's Format tab."

Where do I find that? I can't find where to set the page footer propery. I
can go to the property sheet for the page footer but is not there. ??? I'm
confused.

"fredg" wrote:

On Wed, 19 May 2010 10:36:01 -0700, Dwade wrote:

When I print a report I don't want the page footer to print at the end of the
report
I only want the report footer to print

The page header must print on each page.

The report is for a donation report. Grouped off donation Id, can have any
number of items on each report 1 to xxx,xxx,x though the maxiumum so far is
25 items. which rolls the report to 2 pages.

The report footer contains a signature block and also the same line as the
page footer.
Page footer (="Print Date: "&Now() ="page" & [Page]&" of "&[Pages]
Set the Report's Page Footer property to
Not with Rpt Ftr
You'll find it on the Report property sheet's Format tab.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
.

.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:24 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 OfficeFrustration.
The comments are property of their posters.