Controlling the Mouse Wheel

  • Thread starter Thread starter Can
  • Start date Start date
C

Can

I set up a class module to control the mouse wheel within
Access. It did work great. I used the code in the
article MS KB Article ID: Q278379. It has started
freezing on me so I thought I would try using the
ActiveX .dll method instead. I tried to add Stephen
Lebans ActiveX .dll
(http://www.lebans.com/mousewheelonoff.htm) as a reference
using the Tools -> Reference method. I find the file but
when I go to select it I get the follow error "Can't add a
reference to the specified file."

I am using Access 2000 and have the most up-to-date SR. I
also tried it on different PCs and had the same problem.
Any thoughts?

Can
 
You asked for thoughts -->

Not to be cynical, and I've seen many people desire to
eliminate the mousewheel action, but I would recommend not
restricting the use of the mousewheel.

Why would you not want the mousewheel action? If the
issue is a 1-1 subform, then add code that
enables/disables adding records to the subform on the
_current event.

More importantly, why would you want to have the
complexity of subclassing a form with all its related
intracacies over something rather unimportant that can be
coded around? Almost assuredly, there is a solution that
does not require subclassing.

David Atkins, MCP
 
GreySky said:
You asked for thoughts -->

Not to be cynical, and I've seen many people desire to
eliminate the mousewheel action, but I would recommend not
restricting the use of the mousewheel.

Why would you not want the mousewheel action? [snip]
Click to expand...

Why? Because in Access the mousewheel is a nightmare for users.

EX:
The user moves focus into a TextBox with more text than will display. Once the
control has focus a scrollbar appears on the right side. The user does the logical
thing and hits the mousewheel . Suddenly he has unintentionally navigated 20 records
forward in the form and has no idea what happened. If not controlled this will also
happen with every Combo and ListBox on your forms.
 
Why would you not want the mousewheel action?

In this particular database we have 'browse' mode
and 'edit' mode. It's just a toggle switch at the bottom
of the form. The 'browse' mode was implementing to allow
people to view records and not accidently edit things.

The problem that I've been having is that when they are in
edit mode they use the scroll wheel and accidently edit
the wrong record. I was using the browse / edit toggle to
control the mouse wheel action. If they are in edit mode,
they can't use the scroll wheel.

I realize that there are other ways to implement quality
data and I have several of these things in place already.
This is just one more that seemed relatively easy to
implement.

I also get complaints about how the mouse wheel doesn't
work in combo boxes, Stephen Lebans posted that this will
be a fix in his next release coming in the next few weeks.

So to answer your question, I want to control the mouse
wheel to (a) minimize data entry mistakes (b) make my
users happy with a working scroll wheel inside combo boxes
 
Having one record doesn't work in this particular
database. It's an equipment database that users need to
be able to filter on. Users need to be able to easily
filter on how many pieces of the same equipment are there,
how many work orders have been linked to a piece of
equipment. They need to access this info for diagnostic
purposes, printing off reports with this info just kills
too many trees. Plus paper costs money. I could have
them filter with a form that is not editable but that is
more forms, more buttons and a lot more work for me. Plus
it will become less user friendly for them to have to flip
back to another screen. It's just not an effective
solution for this database.
 
I don't remember saying anything about modifying your
browse mode.

I'll let someone else answer your question; this is
pointless and a waste of my time.

David Atkins, MCP
 
If you are using the newer MouseHook instead of the older MouseWheel, as
my web page asks you to, then you do not register the DLL as it is NOT
an ActiveX DLL, as my Web page tells you. Read the instructions!!!

--

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