Table of Contents in Access 95

[sweed]

I work at a hospital in GR, and we use the One Staff application. We tie into the OneStaff DB to run a routine of macros, and one calls for a Roster to print out with the name of the person and the jobs they have worked in. This report prints a Table of Contents and contains the page number of each department, but the number of the page in the report does not correspond with the number on the TOC. Any ideas? We did add one extra blank table to the report itself, but I don't think Access has parameters on where the TOC can end and begin. Any help would be nice.

Jason

 

[MichaelRed]

sweed,

I would be suprised if anyone here really had any specific knowledge of the nammed app ("OneStaff&quot. Therefore respones to your inquiry will necessarily linited.

In an Ms. Access report with a table of contents, I would expect that the TOC is a subreport embedded in a group or report header. To obtain the page numbers which will print below this header, the system would normally 'run' a copy of the report in background, capturing the page numbers of the various TOC items.

When you add the section to the report, it would appear that the background process does not recognise the added section, and thus does not include it in the TOC information. This results in the mis-information in the TOC.

If this is correct, then the soloution is with the developer of the original report. I would suggest that you refer this to the "owner" of the system.



MichaelRed
mred@duvallgroup.com
There is never time to do it right but there is always time to do it over

 

[sweed]

I actually found my answer. One Staff is a payroll application that is commonly interfaced with Access from time to time, and the problem didn't arise in Access. The problem was defined in Excel, where a macro was built to print the TOC. Inside the macro, there are parameters to allow the pages to print and at a certain point, it says go to the next page. Well, the number was set to 1/24, so every 24 pages, a new page was printed. Since the previous user added an extra field, the number of lines printed was pushed. So we changed the number to 17 for adjustment, and this allowed us to print properly.

Thanks for the help anyway, I understand not many people use those types of applications.

sweed