How to disable scroll feature on mouse.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

learningaccess - 12 Dec 2005 15:43 GMT

I have searched and found this website:

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

But i am not sure how to use it. I tried copying the .dll file into my
windows/system folder, but i am not sure how to input the code into my .mdb
to get it to work. I would like to disable the scroll feature upon opening
the database rather than using a command button. Please advise.

Reply to this Message

Gina Whipp - 13 Dec 2005 14:07 GMT

Have you imported the module into your database?
Open your database select File... Import and find MouseWheelHook...mdb and
select the Module tab and import that module into your database.

After that... just place MouseWheelOFF in the On Load or On Open event of
the form(s) you want to disable mouse wheel scroll. (No command button
required.)

HTH

>I have searched and found this website:
>
[quoted text clipped - 5 lines]
> to get it to work. I would like to disable the scroll feature upon opening
> the database rather than using a command button. Please advise.

Reply to this Message

learningaccess - 16 Dec 2005 22:10 GMT

I now have the module imported into my mdb but am still having problems
getting the MouseWheelOFF to work. When I place that in the On Load or On
Open event, it gives an error stating that there is no such macro or
something along those lines.

> Have you imported the module into your database?
> Open your database select File... Import and find MouseWheelHook...mdb and
[quoted text clipped - 15 lines]
> > to get it to work. I would like to disable the scroll feature upon opening
> > the database rather than using a command button. Please advise.

Reply to this Message

Gina Whipp - 19 Dec 2005 13:26 GMT

Where are you typing it, in the Properties box or in the Module window?

>I now have the module imported into my mdb but am still having problems
> getting the MouseWheelOFF to work. When I place that in the On Load or On
[quoted text clipped - 23 lines]
>> > opening
>> > the database rather than using a command button. Please advise.

Reply to this Message

learningaccess - 19 Dec 2005 14:41 GMT

After i imported the module into my database, i went into the design view of
the form that i would like to disable the scroll feature on, went to the
properties, and typed in MouseWheelOFF on the "On Load" tab. I wasn't sure
that this would work and that speculation was confirmed when i opened the
form and it stated that there was no such macro. Any suggestions.

Thanks again for your help.

> Where are you typing it, in the Properties box or in the Module window?
>
[quoted text clipped - 25 lines]
> >> > opening
> >> > the database rather than using a command button. Please advise.

Reply to this Message

Gina Whipp - 19 Dec 2005 15:16 GMT

You need to go to the On Load event, select Event Procedure when the Module
window opens up, type MouseWheelOFF in that window NOT in the Properties On
Load event window.

> After i imported the module into my database, i went into the design view
> of
[quoted text clipped - 39 lines]
>> >> > opening
>> >> > the database rather than using a command button. Please advise.

Reply to this Message

learningaccess - 19 Dec 2005 15:37 GMT

You are a lifesaver!! That got it.

Thanks again!!

> You need to go to the On Load event, select Event Procedure when the Module
> window opens up, type MouseWheelOFF in that window NOT in the Properties On
[quoted text clipped - 43 lines]
> >> >> > opening
> >> >> > the database rather than using a command button. Please advise.

Reply to this Message

Gina Whipp - 19 Dec 2005 17:58 GMT

Glad to have helped...

> You are a lifesaver!! That got it.
>
[quoted text clipped - 64 lines]
>> >> >> > opening
>> >> >> > the database rather than using a command button. Please advise.

Reply to this Message

Stephen Lebans - 19 Dec 2005 23:54 GMT

Please remember to follow the instructions. The call to MouseWheelOff must
be placed in the form's LOAD event. Further you must only call this function
ONCE from a SINGLE form, generally the form you open first and close last.
This allows you to place the corresponding call to MouseWheelOn in this
form's Unload event.

Signature

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

> You are a lifesaver!! That got it.
>
[quoted text clipped - 64 lines]
>> >> >> > opening
>> >> >> > the database rather than using a command button. Please advise.

Reply to this Message

AJ - 23 Jan 2008 01:30 GMT

I have found this thread and up to now it has been MOST helpful. However,
I'm stuck, I'm no programmer at all a simple novice trying to write a
datebase. I read the last message below "You need to go to the On Load
event, select Event Procedure when the Module

> window opens up, type MouseWheelOFF in that window NOT in the Properties On
> Load event window."

I have tried and tried and it still does not work. I am sure I am the
problem, but need more details to correct. I am using access 2003. I open
the form in design view, then from the form I select Build Event, this is
where I get stuck, what do I do from here. I have a choice of Code, Macro or
Expression builder. BTW, I have followed Lebans instructions too... messed
that up as well, it didn't work either.
Thanks in advance for those with patience for us beginners.

Reply to this Message

MikeLostinWoods - 10 Oct 2006 17:03 GMT

I just decided to go the simple route with:
Private Sub Form_MouseWheel(ByVal Page As Boolean, ByVal Count As Long)
If Me.Dirty Then
DoCmd.DoMenuItem acFormBar, acEditMenu, acUndo, , acMenuVer70
End If
End Sub

I'd rather loose changes than have incorrect or incomplete data enterred in
my database! Foolish users shall do as I tell them! Mu hu hu ha ha haahh!!

> I have searched and found this website:
>
[quoted text clipped - 4 lines]
> to get it to work. I would like to disable the scroll feature upon opening
> the database rather than using a command button. Please advise.

Reply to this Message