Solved

Microsoft Access Report Reset Page Number On Report Footer

Posted on 2016-09-01
6
26 Views
Last Modified: 2016-10-22
On last group record in a access report, the report shows page 1 of 2, the last page of the report shows 2 of 2 in the report footer, how do I reset the page number on the report footer to  page 1 of 1
0
Comment
Question by:rjordanbots
  • 2
  • 2
6 Comments
 
LVL 84
Comment Utility
Why would you consider the LAST page of a 2 page report to be page "1 of 1". If it's a separate report, then create it as such.

That said: If the Report Footer page is always one page, then just use a static Label with a caption of "Page 1 of 1"
0
 
LVL 26

Accepted Solution

by:
Nick67 earned 500 total points
Comment Utility
I don't quite understand.
[Page] of [Pages] is known as a notorious liar.

On last group record in a access report, the report shows page 1 of 2,
Ok, how many pages are there actually
the last page of the report shows 2 of 2 in the report footer,
Because this suggests two
how do I reset the page number on the report footer to  page 1 of 1
Well, you have no control over [Page] of [Pages]

You can try to keep track yourself by tracking Page() and Retreat() events, but that's the same thing Access does and fails to succeed at.
You can try to put a header/footer in a logical place on the report with a PageBreak control in that fires when a section above it grows to be almost to big to fit on the page (which is what causes the lies)  but getting that right is very hard.
You can render the entire report hidden.  Code in the report footer can then put the value of [Page] in a variable outside the report itself.  You then close the report and use [page] of [ThatStoredVariable] -- but you are essentially rendering the report twice for each time it outputs.

Or forget that notoriuos liar [Page] of [Pages] and just go with [Page]

I don't know of any simple joy, myself.
0
 
LVL 49

Expert Comment

by:Gustav Brock
Comment Utility
In the group header, set:

    Me.Page = 1

/gustav
0
 
LVL 49

Expert Comment

by:Gustav Brock
Comment Utility
No response from the questioneer, so delete.

/gustav
0
 
LVL 26

Expert Comment

by:Nick67
Comment Utility
/gustav

Agreed.
Whack it.
The author never replied to any suggestions, or clairified the issue.
0

Featured Post

Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

Join & Write a Comment

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now