Ascertain Report Page #'s

  • Thread starter Thread starter VanW
  • Start date Start date
V

VanW

Is there a way to ascertain what page # a particular
record will occupy on a report? Here is my problem. I've
created a report where each record obtained from the
particular query prints on a single page. A Table of
Contents (SubForm in datasheeet view)prints on page 1. The
records print sequence is different for each client based
on a priority field and then a test total field.
Currently, I am viewing the report for eache client first,
to see which sequence the records will be arranged in on
which page and then manually entering the page # into the
query behind the Table of Contents subform. How can I use
VBA to ascertain which page a particular record will print
on and then populate the page field in the subform.
Primary key is a combination of two fields. Thanks for any
help in advance.
Van
 
VanW said:
Is there a way to ascertain what page # a particular
record will occupy on a report? Here is my problem. I've
created a report where each record obtained from the
particular query prints on a single page. A Table of
Contents (SubForm in datasheeet view)prints on page 1. The
records print sequence is different for each client based
on a priority field and then a test total field.
Currently, I am viewing the report for eache client first,
to see which sequence the records will be arranged in on
which page and then manually entering the page # into the
query behind the Table of Contents subform. How can I use
VBA to ascertain which page a particular record will print
on and then populate the page field in the subform.
Primary key is a combination of two fields. Thanks for any
help in advance.
Van
Click to expand...

Maybe this KnowledgeBase article will put you on the right track:

http://support.microsoft.com/default.aspx?scid=kb;en-us;210269
ACC2000: How to Create a Table of Contents or Index for a Report

Glancing over it, it appears to me that you have to print off the table
of contents as a second report, after the first report has been printed.
I don't know what would happen if you tried to put the TOC as a
subreport on the first report.
 
Back
Top