VBA report pagenumbers (Access 97)

Topic

New Reply

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.

Reply | Quote

Replies

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:

Private Sub Report_Page()
  MsgBox "page " & Page
End Sub

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

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!!

Reply | Quote