Ctrl+Minus

[JayTee]

Hey Guys I am desperate,
I have a big Access DB on a network and someone has discovered that if you
hold the control key down and press the minus key(Ctrl+-) it will delete a
record. I cannot find any code to stop this
Can anyone tell me how to stop users doing this.
Thanks in advance to anyone able to assist.
JT

 

[Allen Browne]

The only guaranteed way to prevent users deleting is to cancel the Delete
event in your forms.

To address this specific keystroke, set the KeyPreview of your forms to Yes,
and then call a generic routine in KeyDown. If it is the Ctrl+- keystroke,
destroy it by setting KeyPress to zero.

Presumably you have already locked the interface down so that users cannot
get to the data directly in the tables and queries.