Generating tables of contents on Access reports header sections

  • Thread starter Thread starter Peter Robinson
  • Start date Start date
P

Peter Robinson

I have a Access 2000 report that consists of about 30
Group Headers, followed by detail relevant to that header.
Each header section begins on a new page, and can be of
variable length (1 page, 2, 3, etc.) dependent on the
number of records per header. The report can be in excess
of 100 pages long, and is printed to Adobe .PDFwriter for
distribution around endusers without Access. I want to be
able to compile a contents page, to enable the endusers to
quickly identify which page(s) the Group Header(s) they
specifically want to see can be found.
I have a table of the Header field values, and so some VBA
to populate an additional field in that table and a
subsequent report might be the solution... Any ideas?
 
In the Microsoft Knowledge Base,
http://support.microsoft.com/default.aspx?scid=kb;en-us;210269 is "ACC2000:
How to Create a Table of Contents or Index for a Report", and
http://support.microsoft.com/default.aspx?scid=kb;en-us;131588 is "ACC: How
to Create a Table of Contents or Index for a Report". Chances are good that
one of these will help you.

If you need to follow up or clarify, please do so here in the newsgroup, not
by e-mail. Thanks.

Larry Linson
Microsoft Access MVP

Larry Linson
Microsoft Access MVP
 
Back
Top