Mouse scroll issue for networked database...?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

Sorry for this question that has already been addressed dozens of times on
this board, but I'm just not getting it :-(

I have the issue that many people have with the mouse scroll; rather than
taking me down the form it jumps to the next record. I've been to
http://www.lebans.com/mousewheelonoff.htm and downloaded his fix but perhaps
I'm not understanding. The database I'm creating is on a network server. Many
users access the database.

3 Questions:
1. Does Mr. Leban's fix have to be installed on each user's computer or can
I activate from the folder on the server where the mdb file resides?

2. Does the utility have to be turned on/off via a command button or can I
somehow have it load automatically when the form load and turn the mouse
scroll back on when the user exits the form?

3. Provided I can use this on a networked system, I am totally baffled as
how to install it. I've read the directions several times but my newbie-ness
prevents me from getting it.

I've also looked at the mousetrap utility developed by GHudson but do no
better with that. Any help would be greatly appreciated. Thanks so much,

David
 
As Stephen says on his site "copy the included MouseHook.DLL into your
Windows/System folder or into the same folder as your application MDB" Since
your application should be split into a front-end (the "application", or
queries, forms, reports, macros and modules) and a back-end (the tables and
relationships) and each user should have his/her own copy of the front-end
on their hard drive, that implies having to install the DLL on each user's
computer.

If you're being unwise enough to have your users share the front-end (or,
even worse, you haven't split the database), theoretically you could get
away with the DLL being on the server, but I wouldn't advise it (any more
than I wouldn't advise not splitting the application!)

You can call MouseWheelOFF (or MouseWheelON) anywhere you want. The example
has it in the code behind a command button, but yes, you could just as
easily put the call to MouseWheelOFF in the Load event of your form, and the
call to MouseWheelON in the Unload event.

Hopefully this makes your 3rd question moot now.
 
Doug,

Thanks for the feedback and, yes, your suspicions are correct I have not
split the database or divided into front end or back ends. I'm creating this
system as I go along and haven't come accross the concept in my own reading.
I'm sure I am flirting with impending disaster for not doing this.

Could you point me in the direction of any articles or websites that would
explain the process and give me some direction on this?

Many, many thanks,
David
 
Hi Doug,

I'm doing my best to follow Leban's directions precisely but I'm running
into problems.

I've loaded Mousehook.dll into the directory where the MDB file resides. I
copied the Mousestop and Mousestart buttons into my form and I've loaded the
appropriate code into the OnClick commands for each. However when I click on
the Mousestop command button I get an error note in the code that highlights
MouseWheelOFF and states Compile Error: Variable not defined.

I'm not sure how to fix this. Any ideas?

Thanks for the help.
David
 
Sorry, I only have the use of Access 97 at present, so I can't actually look
at Stephen's sample.

I believe there should be code in his sample that needs to be invoked when
you open the database, something along the lines of:

hLib = LoadLibrary(CurrentDBDir() & "MouseHook.dll")
 
Did you Import the standard Code module named "modMouseHook" from the sample
MDB into your own MDB?

--

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

Uhh, no...

However, I followed your suggestion and it fixed the problem. Thanks so much
(to both you and Doug) for your ongoing help and infinite tolerance in the
face of my equally infinite learning curve.

Many, many thanks,
David
 
It's my fault David. I will try to find time to update the Web page with
explicit instructions.
Good luck.

--

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