Need a command for scrolling in continuous form.

[Michael R]

Hello.

I would like to replace the defalt Scroll Bars with custom buttons in a continuous form.

I've tryed to make command buttons with the goto next/previous record macros, but those aren't acting in the same way as the scroll bars, for example, the control has to be focused in order for the goto next/previous record macros to work.

So, is there a way to compose a buttons that will imitate the scroll bar?

Much thanks, Michael.

[ADezii]

Hello.

I would like to replace the defalt Scroll Bars with custom buttons in a continuous form.

I've tryed to make command buttons with the goto next/previous record macros, but those aren't acting in the same way as the scroll bars, for example, the control has to be focused in order for the goto next/previous record macros to work.

So, is there a way to compose a buttons that will imitate the scroll bar?

Much thanks, Michael.

The simplest way to mimic the scrolling behavior on a Continuous Form via Command Buttons is as follows:

'In the Click() Event of a Command Button in the Form Footer with the
Caption Scroll Up, place the following single line of code
Private Sub cmdScrollUp_Click()
  SendKeys "{PGUP}"
End Sub

'In the Click() Event of a Command Button in the Form Footer with the
Caption Scroll Down, place the following single line of code
Private Sub cmdScrollDown_Click()
  SendKeys "{PGDN}"
End Sub

[NeoPa]

I think that to imitate the scrollbars with full-functionality is actually quite involved as there are various things the scroll bars respond to :
Clicking above / below; dragging; keystrokes; etc.
Some of the more important (to you) functionality can be mimicked but it's quite detailed work.

[ADezii]

I think that to imitate the scrollbars with full-functionality is actually quite involved as there are various things the scroll bars respond to :
Clicking above / below; dragging; keystrokes; etc.
Some of the more important (to you) functionality can be mimicked but it's quite detailed work.

It would seem as though imitating fully functional Scroll Bars via Command Buttons would be next to impossible until I had a brainstorm. What do you think about using the Auto Repeat property of a Command Button? As long as this Property is set to True, code within the Click() Event of the button will execute as long as the button is pressed. With an appropriate delay factor programmed in to slow down Record Navigation, it may not be as difficult as we think. Of course the other factors that you mentioned such as Clicking above / below; dragging; keystrokes would be next to impossible to duplicate. Checking for BOF and EOF would probably be difficult also because of the Repeat factor. Please excuse me if I am ranting on - just wanted your input.

[NeoPa]

Not at all ADezii, I'm always pleased to discuss matters towards anyone's better understanding (mine included).
Let me first issue another request to initiate Private Message contact though. Can you let me know if you have any difficulty with this (in here or by PM).
Certainly the auto-repeat feature could add similarity to the effect. I would also say that PageUp & PageDown controls could also be added in such a way as to look like the scroll bar. I wouldn't do it myself unless for an exercise, and I wouldn't want to take someone through it on here unless they could communicate well.
I've implemented record level controls on a bound form before to replace the defaults but I would see Scroll bars as an extra level of complication.