By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,543 Members | 2,085 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,543 IT Pros & Developers. It's quick & easy.

Long report

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
On Fri, 08 Oct 2004 13:44:00 GMT, "Paradigm" <al********@hotmail.com>
wrote:

A better approach might be to use Word for your document, and perform
a MailMerge. Now you have a single doc, and no problems with page
numbers. Let each app do what it is best at.

-Tom.

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


Nov 13 '05 #2

P: n/a
I have used Word for documents like this before but in this case I do not
think it suitable. I need to manage revisions, costings, etc. The problem
with Word (apart from having to manage the files produced) is that the user
can then edit the document and make changes that are not recorded elsewhere.
There are also a load of optional clauses where some need to be scored out.
I really need an Access solution.
Thanks
Alex
"Tom van Stiphout" <no*************@cox.net> wrote in message
news:3e********************************@4ax.com...
On Fri, 08 Oct 2004 13:44:00 GMT, "Paradigm" <al********@hotmail.com>
wrote:

A better approach might be to use Word for your document, and perform
a MailMerge. Now you have a single doc, and no problems with page
numbers. Let each app do what it is best at.

-Tom.

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 hadto do it as 5 seperate reports. There are some pages where the text box isset to can grow because the users text could be lengthy. The number of pagesin 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 report5). 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

Nov 13 '05 #3

P: n/a
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.
Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.