Trying to get vscroll to work with a frame. Please assist...thanks.

Posted on 2007-10-19
Last Modified: 2013-12-05
Trying to get the scroll and frame to work right. The scroll needs to go to the top, which it does but the frame needs to go only up  to 100 but it doesn't. Well I can't get it just right. There is a counter right behind it that needs to be visible at all times so the frame needs to drop down so the user can see it, but it isn't quite right.

When the form loads it is okay, but if I use the scroll or go to the next record it is doesn't show the counter or the top of the frame, it almost does. I tried playing with the numbers however I am at a loss, so someone please help me...please?

Private Sub VScroll3_Change()
'VScroll3.Value = 0
'fraMain.Top = 100
'frmMain.fraMain.Top = -VScroll3.Value

End Sub

on page load:
                    frmMain.fraMain.Visible = 100
                    VScroll3.Value = 0

Thanks in advance for the assistance!
Question by:tinapardi
    1 Comment
    LVL 44

    Accepted Solution

    Here are the vscroll properties you will need to set and adjust.


    You will probably need to consider responding to both the _Click and the _Change events.

    Consider setting the .MinValue equal to a negative number and your .MaxValue equal to zero.

    I'm not sure I understand how you are using this frame to show record data, so this is just the first pass at your solution.

    Featured Post

    Integrate social media with email signatures

    Is your company active on social media? Do you also use email signatures? Including social media icons in your email signature is a great way to get fans for free. Let all your email users know you’re on social media quickly and easily, in a single click.

    Join & Write a Comment

    NTFS file system has been developed by Microsoft that is widely used by Windows NT operating system and its advanced versions. It is the mostly used over FAT file system as it provides superior features like reliability, security, storage, efficienc…
    Sometimes drives fill up and we don't know why.  If you don't understand the best way to use the tools available, you may end up being stumped as to why your drive says it's not full when you have no space left!  Here's how you can find out...
    Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
    In this video, we discuss why the need for additional vertical screen space has become more important in recent years, namely, due to the transition in the marketplace of 4x3 computer screens to 16x9 and 16x10 screens (so-called widescreen format). …

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now