<

Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x

MS Access – Adding “Page ‘x’ of ‘y’” Over a Group in a Report

Posted on
7,870 Points
770 Views
1 Endorsement
Last Modified:
Experience Level: Beginner
5:15
Jim Dettman (Microsoft MVP/ EE MVE)
Independent consultant specializing in the writing of custom packages for businesses.
Learn how to number pages in an Access report over each group.

Video Steps

1. Activate two pass printing by referencing the pages property

2. Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to determine what pass your on.

3. Use an unbound control to display the page count

1
Comment
0 Comments

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Join & Write a Comment

If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
When we develop an application in Ms Access 2016 we should also try to protect the queries, macros and table links. I know I may not have a permanent solution but for novice users, they will not manage to break your application. Below is the detail …
Suggested Courses

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month