Hi all,
I am using Access 2003 and need to produce a TOC for a few reports which are about 50 to 100 pages long in the following format
Report:
---Main report showing Title/executive summary
/new page
---Subreport which contains TOC
/new page
---Body of main report
There have been quite a few threads on this,I have been reading and trying different options found, but still can't get it to work.
I am using the Ms technote to do the TOC and I am using the On format instead of On print to build the TOC temp table.
All this works fine if I print the TOC report on its own, but because the subreport opens before the on format event of the main report, the TOC table is not yet populated when the TOC report sub report is generated
The reports are usually printed in pdf and really need to have both in just 1 document.
What seem tobe working is if I create a copy of the main report , which I call when I open the main report. This poplates the TOC table,and when the subreport fires, it actually contains data.
However this solution means that I need an extra report for each report.
Does anyone has a better solution for this?
I researched a bit and seems that even in Access 2007 there is no builtin TOC, so can't upgrade to that version.
Thanks a lot
Babou
I am using Access 2003 and need to produce a TOC for a few reports which are about 50 to 100 pages long in the following format
Report:
---Main report showing Title/executive summary
/new page
---Subreport which contains TOC
/new page
---Body of main report
There have been quite a few threads on this,I have been reading and trying different options found, but still can't get it to work.
I am using the Ms technote to do the TOC and I am using the On format instead of On print to build the TOC temp table.
All this works fine if I print the TOC report on its own, but because the subreport opens before the on format event of the main report, the TOC table is not yet populated when the TOC report sub report is generated
The reports are usually printed in pdf and really need to have both in just 1 document.
What seem tobe working is if I create a copy of the main report , which I call when I open the main report. This poplates the TOC table,and when the subreport fires, it actually contains data.
However this solution means that I need an extra report for each report.
Does anyone has a better solution for this?
I researched a bit and seems that even in Access 2007 there is no builtin TOC, so can't upgrade to that version.
Thanks a lot
Babou
