Results 1 to 8 of 8
  1. #1
    New Lounger
    Join Date
    Aug 2001
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Page 1 of page 3 BY GROUP (Access 97 SR-2)

    Is it possible to print at the bottom of each page "Page __ of __ " where the value refer to the grouped section (in this case, by SSN), rather than for the entire collection of all pages?

    Any help would be appreciated.

    Thanks,
    Sean

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Page 1 of page 3 BY GROUP (Access 97 SR-2)

    I don't think this is possible. At least I've never seen how it can be done. I thought I could do it with a subreport, but neither the Page nor Pages property works with a subreport. The only thing I can suggest is to create a routine that call the routine continually, once for each of your "groups", include that group in a WHERE clause within the OPenReport method.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  3. #3
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Page 1 of page 3 BY GROUP (Access 97 SR-2)

    I've not tried to set the total number of pages this way, but you can set the OnFormat command of the page header to reset the PAGE number, so each section or group starts with 1. You can do it either with a macro or with VBA.
    Wendell

  4. #4
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Columbus, Ohio, USA
    Posts
    286
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Page 1 of page 3 BY GROUP (Access 97 SR-2)

    Sean: Try this link

    http://www.mvps.org/access/reports/index.htm

    Scroll down to " Printing First and Last Page Numbers for Report Groups". I have used it and it works. I think it is what you want. Do read it carefully as it is intense. HTH.

  5. #5
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Page 1 of page 3 BY GROUP (Access 97 SR-2)

    >>I've not tried to set the total number of pages this way, but you can set the OnFormat command of the page header to reset the PAGE number, so each section or group starts with 1. <<

    Setting the Page number is no problem. However, you can't set the PAGES property; it is read-only and is the total number of pages in the report. So, you can determine how many pages in a section in order to be able to be able to number pages: 1 of 2, 2 of 2, 1 of 3, etc.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  6. #6
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Joliette, Quebec, Canada
    Posts
    290
    Thanks
    9
    Thanked 0 Times in 0 Posts

    Re: Page 1 of page 3 BY GROUP (Access 97 SR-2)

    The solution is in redimentioning pages. Go to the access web. There is a solution. But i have not tried it.
    http://www.mvps.org/access/reports/rpt0013.htm

    hth Richard

  7. #7
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Page 1 of page 3 BY GROUP (Access 97 SR-2)

    Richard,

    Thanks. I checked it out, and it certainly is an interesting concept. I'll have to study it more at length (it's a little deep to take it all in on just 1 reading!).
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  8. #8
    Lounger
    Join Date
    Jun 2001
    Location
    Syracuse, NY
    Posts
    41
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Page 1 of page 3 BY GROUP (Access 97 SR-2)

    This is quite possible. Besides the solution offered, there is also a MSKB article with a similar solution, but it uses a table rather then an array to store the page numbers.

    It boils down to forcing the report engine into 2 passes, the first is used to pickup the pages, the 2nd to format a control with the number.

    Jim.

Posting Permissions

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