Help with Scrolling SSTAB

Posted on 2001-09-09
Last Modified: 2008-02-01
I have placed an SSTAB control on a form (MDI Child)

I have to place a scroll bar down one side - so that the user can scroll down past the buttom of the viewable area to see more information.

I have not a clue about how this should be done or even where to start

Pointers to example code ... code solutions etc get the points


Question by:DarrinE

Expert Comment

ID: 6468507
What kind of container is your data sitting in on the SSTab?
LVL 17

Accepted Solution

inthedark earned 200 total points
ID: 6468706
Set up 2 picture boxes:

Place picOuter on the SSTAB and place picInner inside picOuter.

Place all of your controls on picInner.

Set picOuter width and height to fit inside the SSTAB.

How it words:

By setting -1440 it will scroll up one inch.

Set your pics and vscroll up like this:

' get rid of borders at run time but keep for design time
' so you can see where the pciture boxes are
' make the diffeerent colours to aid design
' but at run time merge then into the same colour as the SSTAB


' This is an important line.
picInner.move 0,0

' Now all you need to do is setup you scroll events:

sub vscroll_Change()
   call vscroll_Scroll
End Sub

Sub VScroll_Scroll()
    ' This is the code that makes it work.

    ' The folling code will change the poisition of
    ' picInner.Top making it more negative
    ' because vscroll.max has been setup so that it wont scroll up heigher than it needs to

    picInner.Top = - vscroll.value
End Sub

Hope this helps - please excuse any typos.

Author Comment

ID: 6469016
thanks for the tips guys

I have about 75 editboxes which will be placed on the SSTab - I take it I will have to place these on the Picture control (picInner ??)

LVL 69

Expert Comment

by:Éric Moreau
ID: 6469135
LVL 17

Expert Comment

ID: 6469139
If you already have a form you can select all controls in one hit and cut and paste them into picInner.

Consider the following:

In development mode you want to be able to view as may controls as possible. So you want you SSTAB and picOuter to be as large as possible. You can move then picInner up and down within picOuter to edit the controls. In your formload event, resize and position SSTAB and picOuter to their required positions and  sizes.

Be aware that there are some bugs with SSTab which were only corrected by VB6 SP5.  If you changed the left property of an element the SSTAB display got screwed.

>I have about 75 editboxes which will be placed on the SSTab

With 75 edit boxes you are reaching then point where you should be considering not using textboxes for performance reasons - so it depends on the client's budget and you abillities - it is not so simple to do away with texboxes for $100,000 I can make 350 editboxes appear in less than half a second - if you need better performance it can be acheived.

Hope this helps..

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

LVL 17

Expert Comment

ID: 6469149
I suspect that emoreau's execllent solution works well with a few controls but for raw speed you can't beat:
picInner.Top = - vscroll.value

instead of:

Private Sub ScrollControls()
Dim ctl As Control

    For Each ctl In Me.Controls
        'Check for controls that don't move
        If TypeOf ctl Is VScrollBar Or _
           ctl.Name = "cmdStay" _
            'do nothing
            ctl.Top = ctl.Top + OldScrollPos - VScroll1.Value
        End If
    OldScrollPos = VScroll1.Value
End Sub

Which potentially could be painfully slow with loads of controls. And also invloves 1600% more software.


Author Comment

ID: 6470366
many thanks for the assistance ....

tell me more about this 350 controls in under 1/2 a second I am ineterested in this ....
LVL 17

Expert Comment

ID: 6472047
I didn't say "controls", I said "editboxes", there is a subtle difference.

I will give you more details in a day or so.

Author Comment

ID: 6472344
hmmm... ok missed that

Author Comment

ID: 6473930
inthedark :

Please look for my question about scrolling into view


Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

When designing a form there are several BorderStyles to choose from, all of which can be classified as either 'Fixed' or 'Sizable' and I'd guess that 'Fixed Single' or one of the other fixed types is the most popular choice. I assume it's the most p…
Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
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…
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…

743 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

12 Experts available now in Live!

Get 1:1 Help Now