Scroll Wheel effecting a form

[Dave]

Is there any way to keep a mouse scroll wheel from having an effect on a
form?
This is a single form for data entry and if are part way thru the form and
for what ever reasom use the scroll wheel all the fields on the form are
effected (they dissapear - like going to the next new record).
My suggestion to get a mouse without a scrool wheel was not met with
enthusiasm.

Any help here will be appreciated.

Thanks in advance

 

[BruceM]

The scroll wheel is moving you through the records. Nothing except your
view of the records is disappearing. The records are still there. I
wouldn't think you'd get a favorable response to the suggestion to change
hardware. There is a third-party technique here:
http://www.lebans.com/mousewheelonoff.htm
I think I have heard that in Access 2007 there is a built-in way of solving
the problem, but I'm not sure about that.

 

[Dave]

Thanks for the reply.

I downloaded Lebans solution from the link you previded.
I set the .dll in the same directory as my application (.mdb)
I put this code in the on load event of the first form

Private Sub Form_Load()
'Turn the MouseWheel off
Dim blRet As Boolean
blRet = MouseWheelOFF
End Sub

it did not solve my problem.

I am using Access 2003 (in this case)

My development machine is VISTA
Do you think that could be the issue?

dave

 

[BruceM]

Did you copy the modMouseHook module from the sample database to your
database? I couldn't find the documentation saying to do that, but you need
to make sure modMouse Hook is among the objects listed in the database
window (the window that lists the tables, queries, etc.).

 

[Dave]

Damn! don't you just love us noobs.

yep - there was nothing mentioning that but I should have known some module
was needed

That was the problem and it does in fact work like a charm.

Thanks very much

dave

 

[missinglinq via AccessMonster.com]

Don't feel bad! About 80% of the people who use this handy hack forget to
import the module into their db the first time!