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 Download MS Access 2003

A: Open your Internet browser and navigate to the "Office.Microsoft.com" website. Click "Downloads Categories," "Office Download Catalog" and...(more)

Q:How to Copy an MS Access 2003 Database

A: Stop working in your MS Access 2003 database. Save and close the current object you are working on. Select "File" and "Exit. The database cl...(more)

Q:How to Connect to an MS Access 2003 Database Using SharePoint 2007

A: Log on to your computer and open your Internet browser. Log on to the SharePoint site your company has established. If you do not know your ...(more)

Q:How to Learn MS Access 2003

A: Open your Access software and pull down the "Help" menu, which is located at the top of the screen on the toolbar. Review the in-program tut...(more)

Q:How to Convert Wordpad Into MS Access 2003

A: Log on to your computer and open the Wordpad file you want to use. Click on the "File" menu and choose "Save As" from the menu. Save the W...(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

×