Scroll button

[Scldb]

I'm designing a form and I want to deactivate the scroll button. Everytime someone uses the scroll button, it goes to either a new record or previous record. I don't want this capability. May I get some help?

[NeoPa]

If you look in the properties of the form you should see what you need.

The combination of selections depends on exactly what you require.

[missinglinq]

He's not actually talking about the scroll bar, he's talking about the mouse's scroll wheel! I only know this because this question was also posted in another forum and this was figured out there.

If you're running Access 2007, you already have a function that addresses this issue! Just check with Help.

For all other versions, you'll need some outside help. A gentleman by the name of Stephen Lebans has a sample database that does this and it can be downloaded free 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 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.

Linq ;0)>


As was See what Stephen Lebans has at http://www.lebans.com/mousewheelonoff.htm

[NeoPa]

Thanks for that Linq. It does make better sense in that light of course ;)

[Scldb]

Thanks for that Linq. It does make better sense in that light of course ;)

Yes this works. Got the mousehook.dll all set up and it's running smoothly.

[missinglinq]

Glad we could help!

Linq ;0)>