Results 1 to 11 of 11
  1. #1
    Star Lounger
    Join Date
    Oct 2003
    Posts
    77
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Prev/Next Page (2000)

    I am trying to create a pop-up shortcut menu for use with reports in preview mode.

    I would like to add Next Page & Previous Page to this shortcut menu but cannot find it using the customize menu.

    Is this not available or am I missing something?

    As always...thanks for your quick response.

  2. #2
    5 Star Lounger
    Join Date
    Apr 2003
    Location
    Hampshire, United Kingdom
    Posts
    602
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Prev/Next Page (2000)

    There's no inbuilt toolbar control for this (although there is for next/previous record in forms). You can create macros to go to the next/previous page and then assign them to toolbar buttons though.
    Waggers
    If at first you do succeed, you've probably missed something.

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

    Re: Prev/Next Page (2000)

    What's the point of putting that on a shortcut menu? The report already has navigation buttons at the bottom.

  4. #4
    Star Lounger
    Join Date
    Oct 2003
    Posts
    77
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Prev/Next Page (2000)

    Under what macro Action would I find this?

  5. #5
    Star Lounger
    Join Date
    Oct 2003
    Posts
    77
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Prev/Next Page (2000)

    The preview is set to open maximized and the buttons at the bottom are obscure.

  6. #6
    5 Star Lounger
    Join Date
    Apr 2003
    Location
    Hampshire, United Kingdom
    Posts
    602
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Prev/Next Page (2000)

    Sorry, my mistake. I misunderstood the GotoPage action/function. (I thought it applied to reports as well, but it only applies to forms). <img src=/S/sorry.gif border=0 alt=sorry width=15 height=15>
    Waggers
    If at first you do succeed, you&#39;ve probably missed something.

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

    Re: Prev/Next Page (2000)

    I don't know how to go to the next or previous page in a report using a macro or vba code.

  8. #8
    5 Star Lounger
    Join Date
    Apr 2003
    Location
    Hampshire, United Kingdom
    Posts
    602
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Prev/Next Page (2000)

    BigSteve,

    You can scroll through the pages of a report using the PageUp and PageDown keys. I would encourage your users to do that, but if you absolutely must have some toolbar buttons as well, you could use SendKeys to mimic the pressing of PageUp and PageDown.
    Waggers
    If at first you do succeed, you&#39;ve probably missed something.

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

    Re: Prev/Next Page (2000)

    PageUp and PageDown only send you to the previous page/next page if you set the zoom to "Width". At any other zoom setting, PageUp and PageDown scroll the current page.

  10. #10
    Star Lounger
    Join Date
    Oct 2003
    Posts
    77
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Prev/Next Page (2000)

    We all know how end users can be...I've told them many times to use PageUp/Dn...I've even put an special note on the form that fires these reports. I am at my wits-end with the emails/phone calls so I thought I would put it on the right click since they go there to close, zoom and print.

    Thanks for all your input.

    Steve

  11. #11
    Star Lounger
    Join Date
    Oct 2003
    Posts
    77
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Prev/Next Page (2000)

    I used the SendKeys...works like a charm. It just doesn't know when it is at the first or last page to diable the prev/next command but that's no big deal.

    Again...thanks for your help.

Posting Permissions

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