Page number problem in Access 2 reports! 
Author Message
 Page number problem in Access 2 reports!

I have 4 reports that are run concurrently.

Instead of each report starting with page 1 I need them to start from the last page +1 of the
previous report!

Any ideas

Thanks

A.H
Thanks in advance!

A.H



Thu, 08 Mar 2001 03:00:00 GMT  
 Page number problem in Access 2 reports!
Hi there,
  I first have a menu of reports the user picks from, then I hide this form
which has hidden variables I can use for page counters and such.  In my
reports, I ask the user what page number to start from due to the
application.  I then store the page number in a text box on my hidden form.
In the page header's Onprint property, I put the code for my pageno text box
as:

Me![PageNo] = Me.Page + [Forms]![Reports]![PageHold] - 1

To automatically do this, you would probably have 2 hold fields, on open of
the report move pagestart to pagehold then add the line:

[Forms]![Reports]![PageStart] = Me.Page

This would in effect store the last page for the next report.  Hopefully
this is close.
--
Willie McClure
McClure Imaginations
To reply, replace "nospam" with "isomedia"



Thu, 08 Mar 2001 03:00:00 GMT  
 Page number problem in Access 2 reports!
I have 4 reports that are run concurrently.

Instead of each report starting with page 1 I need them to start from the last page +1 of the
previous report!

Any ideas

Thanks

A.H
Thanks in advance!

A.H



Fri, 09 Mar 2001 03:00:00 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Pausing Access Reports based on page numbers

2. MS Access Report Page Numbers

3. How to Reset the Pages Number on Group Level in a Report

4. Page Numbering for grouped reports

5. Consecutive page numbers on multiple reports

6. Code to place page number text on report

7. return the page number from a report

8. How to check number of page in Crystal Report

9. Page number in a Cross Tab report

10. Total Number Pages in Report?

11. Number of page limit in Crystal Reports

12. Number of pages in Crystal Report

 

 
Powered by phpBB® Forum Software