Page 3 of 4 FirstFirst 1234 LastLast
Results 31 to 45 of 54
  1. #31
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Office 365
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954

    OK thanks. I'll post a link when I add it to my website. Hopefully, sometime next week
    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

  2. #32
    Remster is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Sep 2010
    Posts
    317
    Quick postscript. One thing I forgot to mention is that if you don't want your second subform (the one with the player details) to keep requerying while you're scrolling – maybe because requerying is slow – you can use Form_Timer instead of Form_Current:

    Code:
    Private Sub Detail_Paint()
    
        If Me.CurrentSectionTop > 0 Then
            Me.TimerInterval = 0
            Me.Recordset.Bookmark = Me.Bookmark
            Me.Recordset.Move -Round(Me.CurrentSectionTop / Me.Section(acDetail).Height)
            Me.TimerInterval = 100
        End If
    
    End Sub
    
    
    Private Sub Form_Timer()
        
        Me.TimerInterval = 0
        Me.Parent!PlayerDetails.Form.Requery
    
    End Sub
    You can try different values for the timer; 100 just happens to be adequate for this database on the laptop I'm currently using. You can also make controls on the second subform invisible while you're scrolling and visible again after the requery (making the detail section as a whole invisible looks messy).

  3. #33
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Office 365
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Hi
    Yes I'd already tried that when I was having issues previously.
    Perhaps surprisingly I found there was LESS flicker using a timer than using the original code based on Form_Current
    I definitely wouldn't keep toggling the visibility of the second subform.
    Just finished editing the YouTube video of Mike Wolfe's session on Building Ribbon Interfaces in Code for Access Europe and may start on the web page for this later today

    BTW Are you happy for me to use your @Remster user name in the attribution? If you would prefer me to use your real name, please PM or email me
    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

  4. #34
    orange's Avatar
    orange is offline Moderator
    Windows 10 Office 365
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Colin,
    Unsure where this fits. I downloaded your database ListboxTooltip_v1.61 Subform Scroll Test.accdb from #27.

    When opening frmScrollbar, I get the the uncontrolled scrolling. I keeps this behaviour until I click outside th active Access window. I click anywhere on the taskbar and scrolling stops. If I again click the Access window the scrolling restarts.

    The forum is changing a gif to jpg. I'll attach the gif in the zip.
    I've tried versions of the gif <1 mb, but still not attaching as a gif??
    Attached Files Attached Files
    Last edited by orange; 07-12-2022 at 07:15 AM. Reason: trying to attach gif

  5. #35
    Remster is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Sep 2010
    Posts
    317
    Thanks, I'll PM you.

    What problem have you found with changing the visibility? It works fine for me if I make the controls invisible as soon as the condition is satisfied (Me.CurrentSectionTop > 0 or whatever) and visible again straight after the requery. The only requirement is that the timer interval should be long enough not to expire until all the painting has finished.

  6. #36
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Office 365
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    @Orange
    That's what I was getting earlier but it fixed itself when I decompiled and rebooted.
    I'm unable to explain the cause or why it resolved itself.
    If doing that doesn't help, try using the Form_Timer event instead of Form_Current.

    Did you also get issues with the OP's earlier version?

    @remster
    I didn't find problems. I just didn't feel it added anything to the approach having objects appear/disappear repeatedly especially if that interferes with the redraw
    I'm more concerned about the uncontrolled scrolling. Perhaps it needs a possible warning for anyone who is an epileptic.
    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. #37
    Remster is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Sep 2010
    Posts
    317
    But on my suggestion, objects don't appear/disappear repeatedly. They disappear when you start scrolling and reappear half a second (or whatever) after you stop scrolling.

    To take my earlier example, when you scroll from Bobby Adens to Bobson Dugnutt, what you see in the second subform is:

    1. Bobby Adens
    2. Nothing
    3. Bobson Dugnutt

    At the moment, you see:

    1. Bobby Adens
    2. Jerry Aiggens
    3. Henry Ancaviglia
    4. Donovan Anderson
    5. Tom Aquimo
    ... and so on until ...
    149. Bobson Dugnutt

  8. #38
    Remster is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Sep 2010
    Posts
    317
    With reference to my last post, try the attached.

    __________

    EDIT: Ugh, I haven't got it quite right. Watch this space.

    __________

    EDIT 2: It's fine. I just needed to requery in Form_Load as well. Attachment corrected.

  9. #39
    orange's Avatar
    orange is offline Moderator
    Windows 10 Office 365
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    I downloaded and ran the database in #38 and subform is aligned with topmost player. Vertical scroll works and on last "page", clicking the down button move the record selection as expected.

  10. #40
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Office 365
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Re sample app in post #38.
    Thanks. Yes it works exactly as you describe .... but that's not the behaviour I'm looking for.
    I want to scroll through the records and see the output for each
    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

  11. #41
    Remster is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Sep 2010
    Posts
    317
    Re #39

    Great. I just think it's the tidiest option if you don't want to requery until you've reached your destination.

  12. #42
    Remster is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Sep 2010
    Posts
    317
    By the way, the route to madness is to try and replicate the same behaviour using the Up Arrow and Down Arrow, Page Up and Page Down, and Home and End keys. I managed to get something working, but it wasn't at all satisfactory.

  13. #43
    Remster is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Sep 2010
    Posts
    317
    Re #40

    Oh, then that's fine. I was just throwing it out there for anyone who might find the repeated requerying a problem.

  14. #44
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Office 365
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Yes I agree re #41/#43
    I'll include the code (commented out) in the sample db when I upload it to my website

    Re #42
    Agree with that also, I was going around in circles trying to fix the unwanted & uncontrollable scrolling before it 'magically' fixed itself.
    Now @orange is getting the same behaviour on my 'fixed' version. Did you download & try that? If not please would you do so & let me know whether or not its OK for you.
    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

  15. #45
    Remster is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Sep 2010
    Posts
    317
    Yes, I'm getting the mad scrolling too. I'll look at it this evening.

Page 3 of 4 FirstFirst 1234 LastLast
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 01-16-2018, 02:51 AM
  2. Vertical Scrollbar Appears At Random
    By lccrews in forum Access
    Replies: 3
    Last Post: 10-31-2017, 06:54 PM
  3. Missing Vertical Scrollbar
    By JeffChr in forum Forms
    Replies: 2
    Last Post: 11-21-2014, 07:54 AM
  4. Vertical scrollbar issues with a subform
    By vange2013 in forum Forms
    Replies: 1
    Last Post: 11-27-2013, 09:13 PM
  5. Vertical scrollbar in reports
    By Cedarguy in forum Reports
    Replies: 2
    Last Post: 11-07-2012, 03:15 PM

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