Ignore keydown while code is running

[keal]

Hi,

I have a database with a form and when a user presses a button on the form it runs some vba code, what i would like to do is prevent the users from stopping the code before the subroutine has ended.

Is there a way to make access ignore all keypresses?

keal

Using: Access 2002, Windows XP

[PEB]

Hi,

Usually when a subroutine is activated, the users can't desactivate it pressing other keys!

When the subroutine is executed an other is activated in function of pressed key!

I don't think that in the middle of routine, the executed one will be stoped and activated an other one!

at least the both can be activated running simultanely! but i doubt it!

[keal]

Ok, thanks for your help.

Hi,

Usually when a subroutine is activated, the users can't desactivate it pressing other keys!

When the subroutine is executed an other is activated in function of pressed key!

I don't think that in the middle of routine, the executed one will be stoped and activated an other one!

at least the both can be activated running simultanely! but i doubt it!

[NeoPa]

The Ctrl-Break key combination will normally allow an operator to break into the code, causing it to stop.
To avoid this, or any other keystrokes, you could look at the KeyPress event.

Private Sub Form_KeyPress(KeyAscii As Integer)

End Sub