<

Improve company productivity with a Business Account.Sign Up

x

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

Posted on
7,909 Points
809 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

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Join & Write a Comment

A Case Study of using the Windows API to provide RS232 communications capability in Access without the use of Active-X controls.
A quick solution showing how to control and open a POS Cash Register Drawer using VBA with MS Access.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month