On Fri, 08 Oct 2004 13:44:00 GMT, Paradigm wrote:
I have a contract document that is about 20 pages long with various data
base fields in it. I cannot create an Access report that long so I have had
to do it as 5 seperate reports. There are some pages where the text box is
set to can grow because the users text could be lengthy. The number of pages
in the report is therefore unknown because it depends on the users text.
My problem is that I need to print all 5 reports with a continous page
numbering (starting page 1 on report 1 and ending on the last page of report
5). I cannot fix the numbering on say report 2 because I do not know the
number of pages in report 1 (etc.)
Is there any way of doing this.
Any suggestions appreciated. Thanks in advance.
Alex
Add a new table to your database.
TableName: tblCountPages
Field Name: PageCount
Datatype: Number
Field Size: Integer
Set the value of the field to 0 (Zero).
=========
In the Report Open event of ONLY the first report in the series:
CurrentDb.Execute "Update tblCountPages Set tblCountPages.PageCount =
0;", dbFailOnError
====================
Code the Report Header Format event of each report:
[Page] = [Page] + DLookup("[PageCount]", "tblCountPages")
==================
Code each Report Footer Print event:
CurrentDb.Execute "Update tblCountPages set tblCountPages.PageCount =
" & [Page], dbFailOnError
================
Note: You cannot use a control in any of the reports to calculate
[Pages] i.e. = [Page] & " of " & [Pages], as the first reports will
not know how many total pages there are.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.