Results 1 to 10 of 10
  1. #1
    redekopp is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Oct 2015
    Location
    Saskatoon
    Posts
    108

    Scroll through Continuous form with VBA up/down buttons

    Is there a way to create an up button and down button that will "scroll" through a continuous form?

    Client is using it on a tablet and the scrollbar is too skinny. There appears to be no way to make it bigger without changing the whole tablets scrollbar size which is not an option.

    Anyone have any ideas?

    Thanks!

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,549
    yes, page up, & page down buttons.

  3. #3
    redekopp is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Oct 2015
    Location
    Saskatoon
    Posts
    108
    those are default buttons in access??

    Thanks

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,644
    The keyboard PgUp and PgDn buttons do this.

    My research indicates coding custom buttons on form is not simple. Review http://www.vbforums.com/showthread.p...e-down-page-up

    Easier to just use the keyboard.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    redekopp is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Oct 2015
    Location
    Saskatoon
    Posts
    108
    Is there such a function on an ipad? This is a continuous form running as a subform in a form.

  6. #6
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    6,127
    It is possible to do this using VBA code but its a lot of work for little gain - as already stated the PgUp / PgDown buttons do this well enough with no additional work

    Is there such a function on an ipad? This is a continuous form running as a subform in a form.
    Can Access be used on an iPad? First I've heard of it!
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  7. #7
    redekopp is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Oct 2015
    Location
    Saskatoon
    Posts
    108
    Quote Originally Posted by ridders52 View Post
    It is possible to do this using VBA code but its a lot of work for little gain - as already stated the PgUp / PgDown buttons do this well enough with no additional work


    Can Access be used on an iPad? First I've heard of it!
    Not technically, but the client uses an Ipad with an RDP connection to a remote app of said database. So the Ipad is technically the keyboard option in this scenario

  8. #8
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    6,127
    Quote Originally Posted by redekopp View Post
    Not technically, but the client uses an Ipad with an RDP connection to a remote app of said database. So the Ipad is technically the keyboard option in this scenario
    Access does however run on the windows tablet on which I'm typing this reply.
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  9. #9
    redekopp is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Oct 2015
    Location
    Saskatoon
    Posts
    108
    Quote Originally Posted by ridders52 View Post
    Access does however run on the windows tablet on which I'm typing this reply.
    Absolutely we have a client that uses 30 windows tablets in rural areas running an access database. We can do on screen keyboards and or just change the registry to increase scrollbar width. This particular client only has Ipads, hence the original question.

  10. #10
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    6,127
    Quote Originally Posted by redekopp View Post
    Absolutely we have a client that uses 30 windows tablets in rural areas running an access database. We can do on screen keyboards and or just change the registry to increase scrollbar width. This particular client only has Ipads, hence the original question.
    Increasing the scrollbar width would be useful. Can you tell me the registry key to do this
    I find some database apps work well on a tablet but it very much depends on the form design
    Less clutter & a straightforward layout help in this respect
    I try & design my apps to be 'tablet compatible' as well as 64-bit compatible

    One issue I do have running Access on a tablet is that the VBE toolbars & menubar are missing. Do your Windows tablets have the same issue?
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 7
    Last Post: 09-02-2016, 03:47 PM
  2. Replies: 2
    Last Post: 09-10-2015, 03:21 PM
  3. Replies: 2
    Last Post: 01-01-2014, 02:10 PM
  4. Replies: 2
    Last Post: 10-02-2013, 01:02 PM
  5. scroll bar in form
    By johnnyc11 in forum Forms
    Replies: 5
    Last Post: 06-07-2013, 07:30 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums