Improve company productivity with a Business Account.Sign Up

x
?
Solved

disable mousewheel to navigate through records

Posted on 2002-04-05
7
Medium Priority
?
348 Views
Last Modified: 2011-10-03
Hi,

i've got some annoying problem in access whenever u scroll with a mousewheel access goes to the next or previous record depending on the direction u scrolled, is there a way to disable this ? cause it's very anoying and in some cases u move the wheel without knowing it and ure changing values wich u didn't want to change

please hemp tnx
0
Comment
Question by:joyrider
7 Comments
 
LVL 9

Expert Comment

by:Volibrawl
ID: 6920966
listening....
0
 
LVL 54

Expert Comment

by:nico5038
ID: 6921358
0
 
LVL 59

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 100 total points
ID: 6923752
Also check out the following MSKB article:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q278379

Jim.
0
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

 
LVL 54

Expert Comment

by:nico5038
ID: 7102403
for joyrider

No comment has been added for the last two months.
So it's time to clean up this TA.
I will leave a recommendation in Community Support that this question is:
 - Answered by: JDettman  
Please leave any comments here within the
next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !

Nic;o)
0
 
LVL 5

Expert Comment

by:Netminder
ID: 7120114
Per recommendation, force-accepted.

Netminder
CS Moderator
0
 

Expert Comment

by:apriori
ID: 7244684
The solution presented here seems to be the accepted solution web wide (a dll or class module that uses the windows API). I have implemented a simple solution that seems to be working well and would like to share it to 1) discover any unexpected problems OR 2) hopefully discover this is the solution we are looking for.

Here is the code I placed in the mousewheel event of the form:

Private Sub Form_MouseWheel(ByVal Page As Boolean, ByVal Count As Long)
If Count < 0 Then
    Me.Recordset.MoveNext
Else
    Me.Recordset.MovePrevious
End If
End Sub

There is a flicker but the recordset pointer stays put. Hope this helps.

Cheers,
John Andrew Morrison
0
 
LVL 59
ID: 7244805
John,

  It's a workable technique, but has the drawback of firing off all the events (Before and AfterUpdate if the record is dirty, and OnCurrent).  Using the Win API avoids all of those issues.

FWIW, here's a link to a site with a DLL and sample database that makes it all pretty easy to handle:

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

HTH,
Jim.

0

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
What to do if a split doesn't fit? Or a bunch of invoice lines must be rounded while the sum must match a total? It takes a little, but - when done - it is extremely easy to implement.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
A query can call a function, and a function can call Excel, even though we are in Access. This is Part 2, and steps you through the VBA that "wraps" Excel functionality so we can use its worksheet functions in Access. The declaration statement de…

569 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question