Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Kendrick, Idaho, USA
    Posts
    277
    Thanks
    1
    Thanked 0 Times in 0 Posts

    VBA report pagenumbers (Access 97)

    Is it possible to access the pagenumber value found in the navigation button area of reports? I want to track the pagenumber the user is viewing and have not figured out how.

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: VBA report pagenumbers (Access 97)

    You can use the Page event of the report or the page property to return the value, but what exactly are you trying to do with it?

    If you're looking at it from outside the report (i.e., from a form or external code), you'll need to refer to the page property of the form. If you're doing something within the form itself, you can do something like this:

    <pre>Private Sub Report_Page()
    MsgBox "page " & Page
    End Sub</pre>

    Charlotte

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Kendrick, Idaho, USA
    Posts
    277
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: VBA report pagenumbers (Access 97)

    It seems that both page property and page event only work when moving from one page to the next. If the user pages back to previous page or forward to a previously viewed page, these are non-functional.

    I've been asked to find an alternative to the navigation buttons at the bottom of the report. So I'm trying to create toolbar buttons for next and previous pages - thus I need to access the current page via code.

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: VBA report pagenumbers (Access 97)

    Where were you planning to put those navigation buttons, and what's the purpose of replacing the built-in ones? If it's accessibility for visually impaired, I'm afraid you may have your work cut out for you. You can create navigation tools for forms quite easily, but reports are navigated by formatted page, so I don't see any way to do what you're trying for. Although if it's a visually impaired issue, the reports themselves won't be large enough, let alone the navigation tools. Maybe someone else has a clue.
    Charlotte

  5. #5
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Kendrick, Idaho, USA
    Posts
    277
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: VBA report pagenumbers (Access 97)

    No the problem is not visually impaired, but computer-deficiency! These are factory workers who cannot seem to cope with existing controls and my contact (the boss) requested another approach. Thanks for confirming that this is not simple. It just seems that there should be SOME way of picking up the pagenumber from the current page or from the navigation area!!

Posting Permissions

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