Help with Scrolling SSTAB

Posted on 2001-09-09
Medium Priority
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 800 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 picInner.top= -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 ??)

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

LVL 71

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..

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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

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…
I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

600 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