[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 346
  • Last Modified:

disable mousewheel to navigate through records

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
joyrider
Asked:
joyrider
1 Solution
 
VolibrawlCommented:
listening....
0
 
nico5038Commented:
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
Also check out the following MSKB article:

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

Jim.
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
nico5038Commented:
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
 
NetminderCommented:
Per recommendation, force-accepted.

Netminder
CS Moderator
0
 
aprioriCommented:
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
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
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

Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now