Edit The Report with blank Rows (1 Viewer)

alwazeer

Registered User.
Local time
Today, 05:40
Joined
Nov 9, 2011
Messages
36
Hi All

I took this report from the following Post

Adding blank rows to a report

The report was made by the genius

arnelgp


What I need is to show the Footer of the report when it is one page
and show it on the last page when the report has more than one page
While keeping the blank lines to fit the page
 

Attachments

  • BlankRowsReport.accdb
    528 KB · Views: 227

Jjaeger14

New member
Local time
Today, 15:40
Joined
Dec 26, 2020
Messages
15
Have you attempted placing in the footer what you want, and then using the page footer's on format event to hide/display the content appropriately?

Jack
Owner
Microsoft Access Programmer
 
Last edited:

Gasman

Enthusiastic Amateur
Local time
Today, 12:40
Joined
Sep 21, 2011
Messages
14,038
Report footer?
 

Jjaeger14

New member
Local time
Today, 15:40
Joined
Dec 26, 2020
Messages
15
OK. I guess that was a poor assumption on my part. Instead of trying to hide display the page footer based on the number of pages, use the report footer instead. the report footer displays on the last page of the report (which meets your criterion)

Jack
Owner
Data Control, LLC
 

Attachments

  • report footer.jpg
    report footer.jpg
    56.5 KB · Views: 218

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 20:40
Joined
May 7, 2009
Messages
19,169
see this one.
 

Attachments

  • NewReport.accdb
    736 KB · Views: 173

alwazeer

Registered User.
Local time
Today, 05:40
Joined
Nov 9, 2011
Messages
36
Thanks for your interest
When the number of records is less than 17 the report mode is correct
But when the number of reports increases, example 17 or higher gives the following error message
What I want when the report becomes more than one page, the footer moves to the last page without the need all the blank lines
Suppose we have one set of 28 records, the report will be of two sheets, so the appendix will be on the second sheet and not in the third sheet that contains the rest of the blank lines.
 

Attachments

  • err.png
    err.png
    9.1 KB · Views: 226
  • x3.png
    x3.png
    17.5 KB · Views: 212
  • x2.png
    x2.png
    12.3 KB · Views: 215

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 20:40
Joined
May 7, 2009
Messages
19,169
did you try the NewReport.accdb?
this is what i get if i select Group 1:
grp1 only.png

and this for "all groups"
allgrp1.png
allgrp2.png

and
 

alwazeer

Registered User.
Local time
Today, 05:40
Joined
Nov 9, 2011
Messages
36
Yes, I tried it

What I want is:

I need the first page to be filled with the same area as the footer
then the footer moves to the second page if the report has two pages.

The First Picture If the report one page
The second Picture if the report Two page

i made them by Word
 

Attachments

  • p1.png
    p1.png
    7.7 KB · Views: 168
  • p2.png
    p2.png
    20.6 KB · Views: 223

Users who are viewing this thread

Top Bottom