[AccessD] Strange Report Page Numbering

A.D:

I'll bet that's it.  Thanks for the heads up.  There's probably a better way 
to filter the detail records on the fly.

Regards,

Rocky

----- Original Message ----- 
From: "A.D.Tejpal" <adtp at touchtelindia.net>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Wednesday, April 13, 2005 10:31 PM
Subject: Re: [AccessD] Strange Report Page Numbering


Rocky,

    Under certain situations, the following set of commands are known to 
disturb page numbering.
    MoveLayout
    NextRecord
    PrintSection
    ForceNewPage

    You have confirmed that ForceNewPage is not being used in your report. 
You might now like to scrutinize the other three, wherever occurring. (As a 
test, if you disable these commands, your page numbering should revert to 
normal).

Best wishes,
A.D.Tejpal
--------------

  ----- Original Message ----- 
  From: Rocky Smolin - Beach Access Software
  To: Access Developers discussion and problem solving
  Sent: Tuesday, April 12, 2005 21:15
  Subject: Re: [AccessD] Strange Report Page Numbering


  Charlotte:

  No page breaks.  Three sub-reports in the detail section.

  I have the following events :

  Private Sub Detail_Format
  Private Sub Detail_Print
  Private Sub GroupFooter0_Print
  Private Sub Report_NoData
  Private Sub Report_Open
  Private Sub ReportFooter_Format
  Private Sub ReportHeader_Format

  The format events mostly stick things into text boxes.  I do have :

      Me.MoveLayout = False
      Me.NextRecord = True
      Me.PrintSection = False
      Exit Sub

  in a couple of places which get triggered on certain conditions.

  Any clues there?

  Thanks and Regards,

  Rocky Smolin
  Beach Access Software
  http://www.e-z-mrp.com
  858-259-4334

  ----- Original Message ----- 
  From: "Charlotte Foust" <cfoust at infostatsystems.com>
  To: "Access Developers discussion and problem solving"
  <accessd at databaseadvisors.com>
  Sent: Tuesday, April 12, 2005 8:25 AM
  Subject: RE: [AccessD] Strange Report Page Numbering


  > Does it actually print two pages or just one?  I have seen this, but it
  > has been caused by several different things, so you need to fill in the
  > blanks for us.  Do you have any physical page break in the report? Do
  > you have any formatting that breaks before or after a section?
  >
  > Charlotte Foust
  >
  >
  > -----Original Message-----
  > From: Rocky Smolin - Beach Access Software [mailto:bchacc at san.rr.com]
  > Sent: Monday, April 11, 2005 11:12 PM
  > To: AccessD at databaseadvisors.com
  > Subject: [AccessD] Strange Report Page Numbering
  >
  >
  > Dear List:
  >
  > I have a one page report and at the bottom it prints Page 1 of 2.  I'm
  > using the standard ="Page " & [Page] & " of " & [Pages] to print the
  > page numbers which was actually generated by the Access report wiz.
  >
  > This has never failed before.
  >
  > Has anyone seen anything like this?
  >
  > MTIA
  >
  > Rocky Smolin
  > Beach Access Software
  > http://www.e-z-mrp.com
  > 858-259-4334
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com