Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Canada
    Posts
    284
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Numbering Pages Differently (Access 2000)

    Is there any way to start page numbering back at 1 when the field SchoolName changes? I have a billing printout that prints all the schools, but the client wants the pages numbering by each school instead of the whole report. Is there any way to do this?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Numbering Pages Differently (Access 2000)

    Make sure that your report (I assume that it what you're printing) is grouped by SchoolName, and that you have a group header for SchoolName (it may have zero height). Create an On Format event procedure for the group header section:

    Private Sub GroupHeader0_Format(Cancel As Integer, FormatCount As Integer)
    ' Set page number to 1 when a new group starts.
    Page = 1
    End Sub

    (the name for your group header may be different)

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Canada
    Posts
    284
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Numbering Pages Differently (Access 2000)

    What if I have the page numbering as "1 of 3"? How would I do the "of 3" part of the numbering? The first part of the numbering is working great now, by the way.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Numbering Pages Differently (Access 2000)

    That's a bit more complicated. See <post#=496205>post 496205</post#>, the database attached to that post shows how to calculate the number of pages per group.

  5. #5
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Canada
    Posts
    284
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Numbering Pages Differently (Access 2000)

    Got it to work. Thanks again, Hans.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •