[AccessD] Strange Report Page Numbering

Rocky Smolin - Beach Access Software bchacc at san.rr.com
Tue Apr 12 10:45:56 CDT 2005


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
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 




More information about the AccessD mailing list