<

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x

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

Posted on
8,098 Points
999 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
0 Comments

Featured Post

Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

Audit trails are very important in any system to hold people responsible for certain transactions and hold them to take ownership of their actions. This article is dedicated to all novice "Microsoft Access" developers.
Currency codes can be obtained from many sources. The modules here retrieve them from two sources: ISO itself (the definitive source) and Currency Converter API. Both methods will allow you to maintain a table of current currency codes.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month