Solved

disable mousewheel to navigate through records

Posted on 2002-04-05
7
339 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 9

Expert Comment

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

Expert Comment

by:nico5038
ID: 6921358
0
 
LVL 57

Accepted Solution

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

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

Jim.
0
Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

 
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 57
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

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

738 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