On Mouse Wheel

[Annemarie]

Scrolling the mouse wheel scrolls through records, and I understand I need to
download and install a .dll file. I do not have permission to do this. There
is no way that I can put a .dll file on my server at work. Now, I noticed
that on my form, there is an option On Mouse Wheel where I can put in an
event procedure. This is the code I get when I choose this:

Private Sub Form_MouseWheel(ByVal Page As Boolean, ByVal Count As Long)

End Sub

What can I put in between to change the functionality of the scroll wheel? I
don't care if it is disabled or not, just so it doesn't scroll through
records. Downloading and installing things in the system folders is not an
option.

 

[Douglas J. Steele]

Assuming you're talking about the dll Stephen Lebans has at
http://www.lebans.com/mousewheelonoff.htm there's no need to put that on the
server. As Stephen says "Just copy the included MouseHook.DLL into your
Windows/System folder or into the same folder as your application MDB."

Note that your application should be split into a front-end (containing the
queries, forms, reports, macros and modules), linked to a back-end
(containing the tables and relationships). Only the back-end should exist on
the server: each user should have his/her own copy of the front-end,
preferably on his/her hard drive.

 

[Annemarie]

and if I cannot put a .dll file anywhere?

Assuming you're talking about the dll Stephen Lebans has at
http://www.lebans.com/mousewheelonoff.htm there's no need to put that on the
server. As Stephen says "Just copy the included MouseHook.DLL into your
Windows/System folder or into the same folder as your application MDB."

Note that your application should be split into a front-end (containing the
queries, forms, reports, macros and modules), linked to a back-end
(containing the tables and relationships). Only the back-end should exist on
the server: each user should have his/her own copy of the front-end,
preferably on his/her hard drive.

 

[Douglas J. Steele]

Then, I'm afraid, you're out of luck.

I find it hard to believe, though, that you cannot put the file in the same
folder as your MDB. Remember, the DLL doesn't require any registration or
anything, and in order for the MDB to work properly, you must have Write
access to that folder.

 

[Annemarie]

That's a bummer. The problem isn't that the file will not copy there, the
problem is that I may not be allowed to add such a file to our folders. We
were limited to what type of JavaScript we could use on our web site, so I'm
very causious about adding .dll files to where we store our files. I will
definatly look into whether or not I'm allowed to do so. Thank you for your
help.

 

[Annemarie]

Ok, so I copied the .dll file into the same folder as my database, like the
link said I could do, and copied the code that was listed. Nothing changed.
When I use my scroll button, it still scrolls through all records. Here is my
code:
---------------
'this puts the cursor in the Project Title field

Private Sub Form_Load()
' Turn the MouseWheel Off
Dim blRet As Boolean
blRet = MouseWheelOFF
Project_Title.SetFocus
End Sub

 

[Douglas J. Steele]

What happens when you try and use the sample database? Does the scroll
button behave then?

 

[Annemarie]

It works on the frmSuddata form. When I view the VB code, there is nothing
there.

 

[Douglas J. Steele]

What works on the frmSuddata? There's no way to turn scrolling on and off on
that: it's strictly a subform that's used on the other two forms.

 

[Annemarie]

Ok, there are 2 forms. on the first form, the scroll button scrolls through
records. i'm not sure if that one has the mouse scroll off option. The form i
listed below does not scroll through records, but up and down the page.