Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2005
    Posts
    41

    Unanswered: Diable Scroll Wheel on a mouse..

    I have a form that opens up with all kinds of data a user can enter and change. The issue is if a user happens to use the scroll wheel in Access it changes the record to the blank record that actually dosen't exist. Is there a way to stop this from happening?

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Stephen Lebans has a sample database that does this and can be downloaded at:

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

    Download and unzip the db and take a look. In your db and goto File > External Data > Import and import the module modMouseHook from the sample database.

    You need to place a copy of the MouseHook.dll file in the same folder as your database. It’s normally a Hidden file, so you’ll have to unhide it, Find it, then copy it to the folder.

    In the first form to load in your db use this code:

    Code:
    Private Sub Form_Load()
       ' Turn off Mouse Scroll
        blRet = MouseWheelOFF
    End Sub
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  3. #3
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Depending on how you display the data there is a property of a form / control that is something like "Cycle" or similar which you can set to (if memory serves) 3 different settings.
    All records, (including new?)
    Existing records,
    & this record only.
    George
    Home | Blog

  4. #4
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    The Cycle property doesn't affect the behavior of the mousewheel. The only version of Access that gives any control opver the mousewheel is Access 2007
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •