Open Microsoft Access 2003 on your computer by clicking on the icon on the desktop of your computer.
Close all tables. Click "Open" under the File menu to open a database window.
Click the Relationships icon in the toolbar (or choose "Relationships" from the Tools menu). The Relationships window will open. If you have any relationships established, you will see images representing the tables that are related. The relationships are indicated by a line drawn from a field in one table to the related field in another. If no relationships are established, the window is empty.
If you make any changes to the relationships, save your changes by clicking on "Save" in the File menu before you close the program.
Download the free MouseWheelHookA2k Sample Database and Code from the Lebans Holdings website. Extract the file into a folder on the computer.
Copy and paste the "MouseHook.DLL" file into the folder with the Access MDB file.
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).
Click the "Form Design Tools" toolbar and create a "Command Button" anywhere on your form.
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.
Copy and paste the following code into the VBA editor:
' Turn the MouseWheel Off
Dim blRet As Boolean
blRet = MouseWheelOFF
Close the VBA editor.
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
Download the free basMouseHook Sample database and code from the EverythingAccess.com site. Save the database in a folder on your computer.
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.
Open your "StartUp" form in the forms designer window. Right-click on the form, then click the "Properties" option on the pop-up menu.
Scroll down to the "OnOpen" event procedure and double-click it to enter the VBA editor.
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)
i had office 2003 & 2007 software , but i could'nt open access 2003 , please let me know why???
Open the Microsoft Access 2007 database file on your computer that you want to create a custom ribbon in.
Right-click on the top navigation bar and then click the "Navigation Options" button. Click the "Show System Objects" check box so that it's select, and then click the "OK" button.
Select the "Create" tab and then click the "Table Design" option from the "Tables" group. Enter the "Field Name," "Type" and "Field Size" into the first three column headers of the table.
Enter "ID," "AutoNumber" and "Long Integer" into the three columns of the second row. Enter "RibbonName," "Text" and "255" into the third row of columns. Enter "RibbonXml" and "Memo" into the last row of columns.
Click the "ID" field and then select the "Design" tab. Click the "Primary Key" option and then select the "Save" option from the Quick Access toolbar. Enter "USysRibbons" into the "File Name" field, and click the "Save" button.
Right-click on the "USysRibbons" table from the navigation pane and click the "Datasheet View" option from the shortcut menu. Enter "(AutoNumber)" into the "ID" field and then enter "My Tab" into the "RibbonName" field.
Enter the following code into the "RibbonXml" field:
<tab idMso="TabCreate" visible="false" />
<tab id="dbCustomTab" label="A Custom Tab" visible="true">
<group id="dbCustomGroup" label="A Custom Group">
<control idMso="Paste" label="Built-in Paste" enabled="true"/>
Right-click in the database table and click the "Paste" option. Close the table and reopen the database in your Access 2007 application.
Click the "Microsoft Office" button and then click the "Access Options" button. Select the "Current Database" option and then click the "Ribbon Name" list.
Select the customized ribbon your created and then click the "OK" button. The customized ribbon will be applied to your database.