prevent users selecting records with the roller on mouse 1

[daveonion]

Hi I have a form, but when a user rolls the mouse ball the records are navigated, i only want them to be able to edit the record specified,

any help appreciated

 

[dlamarche]

Hi daveonion

Check the kb article at Microsoft:
Microsoft Knowledge Base Article - 278379
ACC2000: How to Detect and Prevent the Mouse Wheel from Scrolling Through Records in a Form

Click Here

Daniel

 

[daveonion]

Hi Daniel

thanks for the info, we don't actually have VB, so i had to use the access version, however when i roll the mouse it closes access down, i've had a look in the code but i can't actually work out why its happening.

Have you actually used the code yourself or did you make the dll file,
do you know of any reasons why it would just close,

thanks
Dave

 

[daveonion]

thanks works fine now, hadn't closed it before i ran the code.

 

[dlamarche]

Very interesting daveonion.

I have never tried it my self because I'm a keyboard type of guy. My hands are always on the keyboard when I enter data.

So...it worked for you? You copied the code from the site and pasted it in a module. Did you have to work very hard to implementit?

Probably call the routine from the form you're working in.

Anyway I glad it worked out well.

This was my very first post to help someone here. Will I get a star? Loll!

Daniel