How do I disable Intellimouse wheel from within Access?

My database is having major problems when users try to use their wheel on their mouse to scroll. For example - they will open a combo-box and try to use the wheel to scroll on the combo box. Instead of scrolling the list - Access moves to the next record. I can't allow this to happen during edits - and it is REALLY causing headaches.

How can I disable the mouse so it has no affect at all?

I'm using Access 97
Thanks
CEKMAN
LVL 5
cekmanAsked:
Who is Participating?
 
RRRConnect With a Mentor Commented:
Hi, cekman.

In your form allow additions property put False.
It will prevent users goto new record.
If you need to add new records you should on click "NewRecord" button put this:
(For example you have Customers form and you want to add new customer)
1.Create new query that will append new record to the Customers table with parameters from the form (for example Date or Customer ID..).
2. Dim MyLastID as long

Currentdb.execute "QueryName"
MyLastID = DMax("CustID","Customers")

    Forms![CustomersForm].Filter = "CustID = " & MyLastID
    Forms![CustomersForm].FilterOn = True



Try it it is work.

You will do it for all form that you have users scrolling the mouse and get new records. Else you will get many empty records ( customers ).

Good Luck
RRR.
0
 
abaldwinCommented:
From the mouse icon in the Control panel choose the wheel tab.  You can control which options are on and off.

If anyone has a way of doing it in code I would love to see it as well.

Laterdays
0
 
wesleystewartCommented:
First, make sure you have SR-2 installed.  It supposedly fixed some intellimouse booboos.  Next, see this page:

http://www.mvps.org/access/api/api0036.htm

For some sample intellimouse code.  It doesn't seem to show how to "turn off" the intellimouse, but if no one can supply the exact code you might poke around in this sample and find the correct API to do what you want.

Wes
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
wesleystewartCommented:
Here's some stuff from Microsoft regarding programming the intellimouse.  Sorry I don't have any specific solutions, but this seems to be a start:

http://msdn.microsoft.com/library/periodic/period97/ivb97b5.htm
http://www.microsoft.com/hardware/mouse/intellimouse/sdk/?RLD=57

Wes
0
 
cekmanAuthor Commented:
abaldwin: Since I have over 200 users - I can't ask them all to turn off their wheel manually each time they want to use the database - so this won't work form me.

wesleystewart: I'll take a look at the page you suggested - it may take me a while to get back to you.

Thanks for your responses
CEKMAN
0
 
wesleystewartCommented:
I just hope you can find something useful.  It appears that intercepting mouse messages is going to require registering additional .ocx or .dll files on each machine.  Something I'm sure you want to avoid.

Wes
0
 
cekmanAuthor Commented:
RRR - This may be the type of approach I have to take. In my case the form in question is used ONLY to add new records - but they are added 'one at a time' - so perhaps I can figure something out with the properties.

It may be a day or two before I can try any of these ideas - but will let you know what I find out.

Thanks
CEKMAN
0
 
cekmanAuthor Commented:
RRR: I'm awarding the points to you. I didn't end up using the ALLOWADDITIONS property, but this led me to a much simpler approach than trying to mess with the wheel itself.

In essence I created a boolean variable called SAVEOK. I set this field to true whenever the user did something that  meant they really could save/move off of the record.

If this field was false - the BeforeUpdate event got CANCELLED - preventing the user from leaving the record.

I have some more testing to do - but this approach seems to be working.

Thanks to everyon who gave input.
0
 
1wingmanCommented:
I know this topic is three years old, but I came here yesterday looking for a simple solution and found it elsewhere so I wanted to share it here.  Take a look at this knowledge base article: http://support.microsoft.com/default.aspx?scid=kb;en-us;308636

You can find a precompiled dll here: http://www.worship.co.za/BlackandWhiteInc/MouseWheel.htm
0
All Courses

From novice to tech pro — start learning today.