I want the scroll button on the mouse to scroll up and down, not through the records

[jordi20]

This is probably really easy to do, so sorry for the stupid question.

On my forms, the mouse scroll button scrolls through the records, but I want it to scroll up and down the page, like it does when I'm in design view.

Any ideas?

Thanks in advance everyone.

 

[vbaInet]

Maybe this:

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

There's also another one by Terry Kreft and Ken Gletz I think. Google.

 

[jordi20]

I didn't know what to change and what to keep to apply it to my database. I'm afraid I'm not very au fait with programming language - am not even at IT professional, just helping out a friend.

If anyone can dumb it down for me, I'd really appreciate it.

Thanks

 

[missinglinq]

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)>

BTW, you didn't say what version of Access you were using. If you're running Access 2007/2010, you already have a function that addresses this issue! Just check with Help.

Linq ;0)>