Disabling the mouse scroller.

[phillsheen]

Is there a way I can disable the middle mouse scroll wheel from flicking up and down records?
I have a main for with client info on and when i click a button it opens there bank info form. the problem is there will only ever been 1 bank record. Ive taken the naviagaion buttons of the bottom to stop people adding new forms but they keep scolling the mouse button and adding new opens that way and it really messes up my queries further down the line!
Apart from chop off there middle fingers does any one have the answer?

Cheers
Phill

 

[voidcranium]

I use this.

http://www.databasedev.co.uk/disable_mousewheel.html

Stop mouse wheel from scrolling through records in a Microsoft Access form:
Have you ever wanted to prevent your Microsoft Access database users from scrolling through form records with the mouse wheel. It can becoming quite an annoyance when they're editing a record and (for some reason) they use the mouse wheel and zoom to another record.

The following example uses the MouseHook DLL file that is a standard Windows DLL. Do not try to Register it or set a Reference to it from within Access.
The example is adapted using code from Stephen Lebans MouseWheelOnOff sample. Take a look around Stephen's site as there are many good Microsoft Access sample files available.
........

 

[missinglinq]

This is assuming, of course, that you're not running Access 2007! After years of people using Lebans' code, MS finally added a similar feature to the latest version.

 

[phillsheen]

I took some working out but i got there eventaully!
Cheers!

 

[dsfcom]

This is assuming, of course, that you're not running Access 2007! After years of people using Lebans' code, MS finally added a similar feature to the latest version.

missinglinq,

I've found that 2007 won't let you scroll in Single-form view but it will in Continuous-form view. I like to be able to scroll in Single-form view so how do I allow it? I've searched this forum and everyone seems to want to disable it but I need it can can't find anything in help or here that gives me any ideas.

 

[humph]

Hi - got this all to work great but I have a question in that I want to turn my access database into an MDE file with no mouse on a number of forms.

Is there any way the mousehook dll file can be included - my initial thoughtrs are unlikely but people on these forums have come up with the impossible before so heres hoping.

Thanks in anticipation

Humph