How do I stop changing records in forms with the mouse wheel?

[Guest]

When I am in a form I don't want it to change records when I roll the mouse
wheel. I would rather have it just slide the page around but if nothing
else, I'd be happy just disabling the wheel function.

Any suggestions??

Thanks

David

 

[Gina Whipp]

I found this and it works great for me...

http://www.lebans.com/mousewheelonoff.htm

 

[Guest]

I like the idea, I just cant get it to work.
I have copied the .dll file to the directory with the mdb program. I have
included the code under the OnLoad portion of the properties for the form. I
still can not get the mouse wheel to turn off.

I figure I'm doing something simple wrong but its eluding me. Any help will
be greatly appreciated.

David

 

[Gina Whipp]

DId you import the modMouseWheel into your database?

 

[Guest]

I don't think so. Where would I find it?? I loaded the .dll file and put in
the code on the webpage. And that is all.

 

[Gina Whipp]

It's in the database you downloaded or did you download it? You need to if
you did not.

 

[Guest]

I have the database and the .dll file. Do I need to copy the module
(modMouseHook) from the A2KMouseWheelHookVer22.mdb to my application?

 

[Gina Whipp]

Yes

I have the database and the .dll file. Do I need to copy the module
(modMouseHook) from the A2KMouseWheelHookVer22.mdb to my application?

 

[Guest]

Thank you for the help. A little playing around and I got it to work.

Thanks

 

[Guest]

I might be the only one who took a while to figure out exactly how to get the
dll file to work, but here's what I did... (I was trying to get the mouse
wheel to stop working on a simple form with no subforms, etc.)

(1) Put a copy of dll file in same folder as database.

(2) Open the sample database file from the lebans website (comes in the zip
folder with the dll file).

(3) Export the module modMouseHook by right clicking it and selecting
Export File... save on desktop.

(4) Close sample database and open your database.

(5) Under Form/Load, paste the following:

' Turn the MouseWheel Off
Dim blRet As Boolean
blRet = MouseWheelOFF

(6) Import the modMouseHook by right-clicking on the Modules folder and
selecting Import File.

That should do it. I'm a novice user who is probably over my head, but I
had to work for a while to get it to work, and thought this step-by-step
explanation might help someone. All of the above steps are performed in the
code window.

Tom

 

[Guest]

I tried the steps below but get amnot ableto save the module to my desktop.
Running XP Pro and Office 2003

Any help would be appreciated. Trying to change wheel function so it doesnt
scroll through records, but rather down teh screen of current record

M

 

[Guest]

I couldn't save it to my desktop either as I have 2003 as well. But, I was
able to Export it directly into the database where I need it. Then, it worked
perfectly!