Results 1 to 8 of 8
  1. #1
    Lounger
    Join Date
    Sep 2001
    Location
    Philadelphia suburbs
    Posts
    29
    Thanks
    0
    Thanked 0 Times in 0 Posts

    go to next page (2003)

    I have a tabular form, and I want to create a button that allows the user to go to the next page. Could anyone tell me the best way to do this?

    Thanks,

    Sue

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

    Re: go to next page (2003)

    Hi Sue, welcome to the Lounge. Just to clarify, by "next page" do you mean next tab or next record?
    Waggers
    If at first you do succeed, you've probably missed something.

  3. #3
    Lounger
    Join Date
    Sep 2001
    Location
    Philadelphia suburbs
    Posts
    29
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: go to next page (2003)

    Hi Waggers,

    Sorry, I wasn't clear. Assuming there are 20 records listed on a screen, I want to go to the next group of 20 records.

    Thanks,
    Sue

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

    Re: go to next page (2003)

    I don't think there is a specific command for this, but you could use SendKeys:

    Private Sub cmdNext_Click()
    SendKeys "{PgDn}"
    End Sub

    If you also want a button to go to the previous page, use PgUp instead of PgDn.

  5. #5
    Lounger
    Join Date
    Sep 2001
    Location
    Philadelphia suburbs
    Posts
    29
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: go to next page (2003)

    Thank you Hans, I'll give it a try.

    Sue

  6. #6
    Lounger
    Join Date
    Sep 2001
    Location
    Philadelphia suburbs
    Posts
    29
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: go to next page (2003)

    Hans,

    I tried SendKeys, and it worked, but sometimes I have to click twice to get to the next or previous page. Other times, just one click will do it. Do you have any idea why that would be, and how I could fix it so that only 1 click is required?

    Thanks,
    Sue

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

    Re: go to next page (2003)

    SendKeys is kind of flaky, since you cannot control exactly what it will send the keystroke to.

    You might be better off putting an label on the form instructing the users to press Page Down to go to the next page...

  8. #8
    Lounger
    Join Date
    Sep 2001
    Location
    Philadelphia suburbs
    Posts
    29
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: go to next page (2003)

    Ok, I'll try that approach.

    Thanks again for your help.

    Sue

Posting Permissions

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