Using Ctrl and Minus

[JayTee]

I have a large database on a multi usr system and have come across a problem
whereby some of the users have woken up to the key combination of Ctrl
+-(Minus) which promptly deletes the current record. I have taken great
steps to ensure no data can be deleted by anyone until this happened.
Can anyone tell me how I can stop these keystrokes.I am familiar with Access
code.
Also, if it is not too involved, is there a way to stop the scroll button
from working.

Thanks
JayTee.

 

[Douglas J. Steele]

I think you should be able to create an AutoKeys macro that remaps that key
combination to something more innoculous.

Check http://msdn2.microsoft.com/en-us/library/aa159349(office.10).aspx and
http://msdn2.microsoft.com/en-us/library/aa170264(office.10).aspx for
details. (Don't worry if you're not using Access 2000: it applies to all
versions)

 

[missinglinq via AccessMonster.com]

Like a message box that says "What the $%^&* do you think you're doing!"

I think you should be able to create an AutoKeys macro that remaps that key
combination to something more innoculous.

Check http://msdn2.microsoft.com/en-us/library/aa159349(office.10).aspx and
http://msdn2.microsoft.com/en-us/library/aa170264(office.10).aspx for
details. (Don't worry if you're not using Access 2000: it applies to all
versions)

I have a large database on a multi usr system and have come across a
problem whereby some of the users have woken up to the key combination of

[quoted text clipped - 7 lines]

Thanks
JayTee.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com

 

[missinglinq via AccessMonster.com]

Re: Stop the scrolling

A gentleman by the name of Stephen Lebans has a sample database that does
this and can be downloaded at:

http://www.lebans.com/mousewheelonoff.htm

First, download and unzip the db and take a look. Go into your db and goto
File > External Data > Import and import the module modMouseHook (I think
that's the name) from the sample database.

Next, use your FIND feature in Windows to make sure you have the file
MouseHook.dll on your PC. You should, it's a standard Windows file. You may
have to go into Windows and select "Show hidden files" then run FIND. You
need to place a copy of this file in the same folder your database resides in.


And finally, in the first form to load in your db use this code:

Private Sub Form_Load()
' Turn off Mouse Scroll
blRet = MouseWheelOFF
End Sub

 

[John W. Vinson]

I have a large database on a multi usr system and have come across a problem
whereby some of the users have woken up to the key combination of Ctrl
+-(Minus) which promptly deletes the current record. I have taken great
steps to ensure no data can be deleted by anyone until this happened.
Can anyone tell me how I can stop these keystrokes.I am familiar with Access
code.

The Form's BeforeDelConfirm event can be cancelled.

If you let users see table datasheet view... you're probably out of luck. You
could use Access security and deny delete privileges to the user logon, but
this would probably make it much harder to legitimately delete records.


John W. Vinson [MVP]