Create TOC/Index in Access Report, Part 3

In this Microsoft Access tutorial, we'll tackle creating a dynamic Table of Contents, complete with group page numbers, to organize reports efficiently. This is Part 3 of 3.

Members

Members will learn how to make the Table of Contents dynamic in size, so the page numbers will stay accurate regardless of the size of the TOC.

•  01. Free Video
•  02. Extended Cut Video - Silver Members
•  Database Download - Gold Members

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

Prerequisites

• Table of Contents, Part 2

Links

• SendKeys
• ISO Date Format
• DDQ Not SQ

Update

• Platinum Member Matt Hall recommended something I never thought of: "To stop the flicker, you might set the report to acHidden for all but the last pass." Brilliant! Thanks, Matt.

Recommended Courses

• Access Developer Courses

Table of Contents Series

• Table of Contents, Part 1
• Table of Contents, Part 2
• Table of Contents, Part 3

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Diamond Sponsors - Information on our Sponsors Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

TechHelp Access, Generate Table of Contents, Access Report Index, Dynamic TOC, Group Page Numbers, VBA Report Navigation, SendKeys Command, TempVars in Access, Debug Compile VBA, ACCDE File, VBA DoEvents, Report Footer Index, Sort List by Name, Tech Help Video.