Hello,

I have to start a Command_Click event with the simulation of pressing the
PgDown-key. Is this possible?

Private Sub Command_Click()
'press the PgDown - key
End Sub

Thanks

In order to take on the function of the keydown event in a click event
of a command button would require overloading the click event of the
command button. Overloading is an Object Oriented programming feature
(OOP). So yes, this would be doable in an OOP environment. But VBA is
not an OOP environment. So this would not be doable in VBA.

However, if the goal is to achieve a scrolling type of function with a
command button in VBA, this can be done but would require some coding
(what I call spaghetti coding).

So the question now would be if it is worth the effort to write a bunch
of code in VBA to achieve the same functionality you could achieve in
OOP with one or two lines of code.

Rich

*** Sent via Developersdex http://www.developersdex.com ***

Daan wrote:

SendKeys "{Enter}{pgdn}"
MsgBox "Beam me down, Scotty"
End Sub

Stretching
http://www.youtube.com/watch?v=DlP0XAifbm8

"Salad" <oil (AT) vinegar (DOT) com> schreef in bericht news:13t0fg243upg606 (AT) corp (DOT) supernews.com...
I am guessing the OP only wanted Sendkeys "{PgDn}"

What's the PageDown 'doing' exactly ??
Maybe you can code 'the other way around' ??
e.g When moving to another page you might as well do a DoCmd.GoToPage 2
==> Be aware that Sendkeys will not work with Vista anymore.

Arno R

Arno R wrote:

That's true. But if you don't give Sendkeys something to respond to it
simply sits there...waiting. I'm basically faking the thing out by
presenting a msgbox that the human eye would never see.

Miku
http://www.youtube.com/watch?v=XtsF3ZjkKvY