Mouse Wheel

[AckAttack]

So I'm kind of green when it comes to using Access, and deffinately green when it comes to coding...

I am trying to figure out a way to disable the mousewheel from going to the next record when i use it. Any help would be awesome

 

[Galaxiom]

You can find a lot of answers with Google. Here is one.
http://www.databasedev.co.uk/disable_mousewheel.html

 

[AckAttack]

Thanks for the help

 

[missinglinq]

The link GalaxiomAtHome gave leads to Stephen Lebans hack for doing this, which has been the gold standard for a number of years now. Microsoft finally included a standard function to cover this in version 2007.

 

[AckAttack]

Hopefully this will do it, I got my boss breathing down my neck asking when I'm going to have this done

 

[missinglinq]

Here's a short step-by-step for installing/using Lebans little gem:

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 from the sample database. Next make sure you have the included file, MouseHook.dll, in the same folder your database resides in. The following code needs to run before the mousewheel will be locked:

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

If you have one form that always loads first in your db, place the code there. If the first form to load varies, place the same code in each form.

You should be set now.

 

[Jen_RT]

Here's a short step-by-step for installing/using Lebans little gem:

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 from the sample database. Next make sure you have the included file, MouseHook.dll, in the same folder your database resides in. The following code needs to run before the mousewheel will be locked:

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

If you have one form that always loads first in your db, place the code there. If the first form to load varies, place the same code in each form.

You should be set now.

Just want to say thanks for providing a detailed description on how to do this. I have spent hours looking for a solution & finally this one works. Cheers

 

[DCrake]

I see the On mouse wheel event but there are no default options. Do you have to personalise it with UDF's

 

[Jen_RT]

I'm fairly new to access. I only did what its said above and didnt personalise anything. I'm using access 2003 if that helps.

 

[SOS]

Microsoft finally included a standard function to cover this in version 2007.

Well, not really a function, but a form event.