Brothersoft.comWindows|Mac|Mobile|Games

|Message

Solve software problem quickly Share experience to help others Improve the ability of solving problem
How to Disable the Mouse Wheel in MS Access 2003

11/16/2011 09:43 by KCornell

First answer posted by TommyB at 11/16/2011 09:43
Add Your Answer
10~1000 characters in length CAPTCHA:
1 Answers
  • TommyB
  • Call a DLL File from Code Manually
    1. Download the free MouseWheelHookA2k Sample Database and Code from the Lebans Holdings website. Extract the file into a folder on the computer.

    2. Copy and paste the "MouseHook.DLL" file into the folder with the Access MDB file.

    3. Open the Access database. Find and open the "StartUp" form in the list of forms for your database (Your start form may have a different name).

    4. Click the "Form Design Tools" toolbar and create a "Command Button" anywhere on your form.

    5. Right-click the Command Button and click the "Properties" option on the pop-up menu. Scroll down to the "OnClick" option and double-click the empty field to open the Visual Basic for Applications (VBA) editor.

    6. Copy and paste the following code into the VBA editor:

      ' Turn the MouseWheel Off

      Dim blRet As Boolean

      blRet = MouseWheelOFF

    7. Close the VBA editor.

    8. Create another "Command Button" on any other form in your database to turn the scroll wheel back on before you exit the database. Enter the following code behind the Command Button in the "OnClick" code:

      ' Turn the MouseWheel On

      Dim blRet As Boolean

      blRet = MouseWheelON

    Import a Module into the Access Database
    1. Download the free basMouseHook Sample database and code from the EverythingAccess.com site. Save the database in a folder on your computer.

    2. Open your database in Access. Click the "File/Import" option and then select "Modules." Browse to the folder where you saved the basMouseHook database and import the basMouseHook code module from the sample database.

    3. Open your "StartUp" form in the forms designer window. Right-click on the form, then click the "Properties" option on the pop-up menu.

    4. Scroll down to the "OnOpen" event procedure and double-click it to enter the VBA editor.

    5. Copy and paste the following code in the "OnOpen" event procedure:

      Private Sub Form_Open(Cancel As Integer)

      Static MouseHook As Object

      Set MouseHook = NewMouseHook(Me)

      End Sub

  • Was this answer helpful? 00 · 11/16/2011 09:43
Add Your Answer
10~1000 characters in length CAPTCHA:
Related Questions
Q:How to Delete the Contents of Tables in MS Access 2003

A: Select the "Start" button on your desktop and then click the "All Programs" button. Double-click the "Microsoft Access 2003" option from the...(more)

Q:How to Encrypt Databases in MS Access 2003

A: Open Access 2003 and click "File." Select one of the recently-opened databases at the end of the File menu. The database opens. Click "Too...(more)

Q:How to Customize a MS Access 2003 Template

A: Open Access 2003 and select "New." The right task pane appears. Type "Address" in the search box and click "Go." Access displays address dat...(more)

Q:How to Size a Query Window in MS Access 2003

A: Double-click the query you want to open. Wait for the query to open and check the top-right corner of the query window for a series of three...(more)

Q:How to Format the Proper Case in MS Access 2003

A: Open the query you want to change the text format in. Click the "Design View" icon. Click the "Close" button if the Show Table dialog bo...(more)

0 people are following

Ask a question now
Write a title for your question

Microsoft Access 2010

Track and report important information with easy-to-use database tools.
Latest version:14.0.4760.1000
License:Shareware
OS:Windows 7/Vista/2003/XP
Total downloads:332
Rank:0 in Database Management
Download It

Share with friends

New features is coming

  • 1. Providing high-quality answers to be a verified Q&A expert
  • 2. Ask and answer questions to get Brothersoft credits

Added Successfully!

×

Are you sure to delete your answer?

NoYes

×

Are you sure to choose it as the best answer?

NoYes

×

Voted Successfully!

×

You can't vote for yourself

×

You can't choose your own answer

×