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

Posted on 2007-10-19
Medium Priority
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 46

Accepted Solution

aikimark earned 2000 total points
ID: 20113259
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


Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever visit a website where you spotted a really cool looking Font, yet couldn't figure out which font family it belonged to, or how to get a copy of it for your own use? This article explains the process of doing exactly that, as well as showing how…
In this modest contribution, I want to share with the IT community (especially system administrators, IT Support Engineers and IT Help Desks) about Windows crashes/hangs and how to deal with these particular problems.
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…

839 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