Lebans Mouse Wheel Off error

[dogmelissa]

When I try to load the dll in my code references (as it says on the
Lebans website), it gives me an error "can't add a reference to the
specified file". I'm not sure what I'm doing wrong, but I'd appreciate
any help. I am using MS Access 2003 and downloaded
A2KMouseWheelHookVer22, and extracted it to the same directory as my
database.
Maybe my process for getting Access to understand where the file is
isn't correct, I'm not sure.
Thanks,
Melissa

 

[Ken Snell \(MVP\)]

If you put Stephen's dll file in the same folder where your front end is
located, then you need do nothing more. You do not need to add the dll file
to the References list in ACCESS; ACCESS will find the dll file when you
call the subroutines that need it. This is one of the magic results of
Stephen's excellent feature.

 

[Stephen Lebans]

Melissa you are asked directly NOT to set any References or invoke ActiveX
Registration on the DLL file.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[dogmelissa]

When trying to understand how to install/use this program, I read the
whole page associate with it. At the bottom of the page is this text:
"Adapted from MS KB Article ID: Q278379

' You must set a Reference to the the file MouseWheel.DLL
' The file is included in this archive.
' After you SAVE it to a folder of your choice then you must
' go through the following steps to tell Access where this
' file is.

' 1. Open any Form in Design View, Then go to the View menu and
' select Code from the drop down menu.
' Alternatively you can open any Class or Code module.

' 2. Select the Tools->References Menu

' 3. Select the Browse Button and go to the folder where you saved
' the MouseWheel.DLL file. By default the file browser will
' only show "files of type" Type Libraries (*.olb,*.tlb).
' In order for for the
' MouseWheel.DLL file to appear you need to click on the
' "files of type" Combo and select the entry for
' Executable Files (*.exe, *.dll)"

So please explain to me how that specifically says *not* to locate this
file in the References?
If this is the incorrect way of doing it, then it should be removed
from the page.

Melissa

 

[dogmelissa]

Ok.. I tried copying the code to activate the program that's on the
site:
"Private Sub Command14_Click()
' Turn the MouseWheel Off
Dim blRet As Boolean
blRet = MouseWheelOFF
End Sub"
.... for use when the button on my startup screen to load the "main"
form is clicked.

Lo and behold, it did nothing. The dll file is in the same directory as
the database (M:/) and has not been modified in any way.
So I'm obviously doing something different than most users and this
won't work for me.

Thanks anyhow. I guess I'll just have to get used to remembering *not*
to use the scroll button.
Melissa