Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Ctrl+Minus
0 views
Skip to first unread message
JayTee
Oct 8, 2008, 3:27:07 AM10/8/08
to
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
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
Oct 8, 2008, 3:39:16 AM10/8/08
to
The only guaranteed way to prevent users deleting is to cancel the Delete
event in your forms.
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.
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"JayTee" <jten...@bigpond.net.au> wrote in message
news:fhZGk.4026$sc2....@news-server.bigpond.net.au...
0 new messages