Creating a "Table of Contents" Report

[currie]

Hi all,

I have created a report that extracts and groups data from a single table. This report groups the different categories (its an Emergency Plan, so there are categories such as "Police Departments", "Fire Departments", etc).

My question is - I want to create another report that will display a table of contents for this report. I want it to show each category and the page that it starts on. Is there some way to do this?


Thanks!


- Ryan

 

[Pat Hartman]

This article expains how to do it.
http://support.microsoft.com/support/kb/articles/Q131/5/88.asp?PR=ACC

There is a working example of this solution in rptsmp97.mdb. You can download it from the Microsoft download site. Be sure to also get frmsmp97.mdb, qrysmp97.mdb and any of the other sample db's that look interesting. It would be worth your while to study them.
http://www.microsoft.com/downloads/search.asp

 

[currie]

Pat,

Thanks so much! Have you ever used this particular example before? I downloaded the sample, and added the code to my project. When I run the report, it just appears for a second and then goes into Design mode rather than Preview mode. It isn't dumping any of the categories into the TOC table for some reason. I've checked everything obvious, I must be missing something.

Any idea?


Thanks again,


- Ryan

 

[currie]

Got it working, *finally*.


Thanks again!


- Ryan