Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Mouse Wheel event

Posted on 2016-10-27
2
Medium Priority
?
42 Views
Last Modified: 2016-10-28
In a subform on a main form I am trying to prevent the mouse wheel allowing the user to move to other records. I have tried this but it does not work.

Private Sub Form_MouseWheel(ByVal Page As Boolean, ByVal Count As Long)
If Page = True Then
        DoCmd.GoToRecord , AcRecord = acPrevious
End If
End Sub

I am trying to disable the mouse wheel
Any ideas? Access version 2002
0
Comment
Question by:DatabaseDek
2 Comments
 
LVL 85

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 2000 total points
ID: 41862384
Wayne over at EverythingAccess.com has a good solution to this:

http://www.everythingaccess.com/tutorials.asp?ID=A-new-method-for-disabling-the-Mouse-Scroll-Wheel-in-Access-forms

There is a downloadable demo there that shows how to implement it.
0
 

Author Closing Comment

by:DatabaseDek
ID: 41863463
Excellent solution. Quick and easy!
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

876 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