Mouse Wheel Problem

[Len Boorman]

I have an application Acc97 and Acc 2000 running on Win 95, NT,2000 platforms and I am having a problem when people use the mousewheel on certain add and edit displays.

Is there a way that I can easily prevent Users using a mouse wheel (apart from smashing the damn thing.)

A disable mouse wheel as an Event procedure on Opening Form would sound good to me but I do not know if it can be done or how.

Comments appreciated

Len B

 

[commandolomo]

Hi Len

I believe your question has been answered many times before in this forum, by previous posts. I would suggest you use the "Search Forum" option that resides over the "Replies" & "Views" columns on the main forum page & and the Sample Database forum, and search for various keywords - "mouse wheel," "mouse trap", "mouse trapping" (to name a few), and you may yield a solution to your question!

HTH

PJL

 

[BarryMK]

Len I use this A97 which I found some time ago on the forum. You need to put the load and unload events on each form and bingo! Cheers

 

[ghudson]

Searching is so much fun...

Links to Mouse Wheel solutions

Here is my favorite...

A Better Mouse Trap

 

[Len Boorman]

Hi Len

I believe your question has been answered many times before in this forum, by previous posts. I would suggest you use the "Search Forum" option that resides over the "Replies" & "Views" columns on the main forum page & and the Sample Database forum, and search for various keywords - "mouse wheel," "mouse trap", "mouse trapping" (to name a few), and you may yield a solution to your question!

HTH

PJL

commandolomo
I am very aware of the search functions. I have used them many times before. I accept that I should have done this first although in my defense I am under intense pressure at this time, but as a member with a relatively small post count compared to some on this occassion I ask for a little slack.

Len

 

[Len Boorman]

Len I use this A97 which I found some time ago on the forum. You need to put the load and unload events on each form and bingo! Cheers

Cheers Barry I will give this a shot. Have you tried using it onA97 and then converting to A2000 by any chance.

Edit
Now had the chance to look at it more closely and must admit to being baffled by the code, but I joined this forum cos it has a whole bunch of experts.

Just a thought.

If I put this on the Load and unload event on my opening form will it carry through the application so to speak.

I only actually have two forms where the problem exists. An Add Data form amd an Edit Data form but was just curious.



len

 

[BarryMK]

Hi Len

I've only got A97 at work so I can't say if it's compatible with A2000.

I'm using it on several databases and it just does what it says on the can. I haven't had any problems with it at all. Only downside is you have to add it to every form that can be scrollled, unless one of our resident experts can make it do otherwise. I have it on almost all forms on a 15 form database where the back end resides on our main server and front ends are installed on pc's both in the building and at remote locations. Indeed I first used it because the remote pc's were creating thousands of new blank records every time someone hit the wheel! Along with a pop up calendar form it's virtually a standard item on any database I build here.
Barry

 

[Len Boorman]

Barry

Thanks for the info. banged it into a Test copy of the application where I am having a problem (1 User out of about 50). Yup it was the blank record attempt that was the problem but PK was chucking up error message which was totally confusing the user.

Will let you know how I get on re the 2000 situation

Len B

 

[Len Boorman]

Hi Barry

Yup fine on Win 2000 with A97. I suspect that it will be okay on 2000 since it really is the OS that it is trapping.

I tried to tweak for Win 95 but no success there. There is a comment in the Module for Win 95 but that does not appear to work.

Any Ideas
???

Len

 

[BarryMK]

'Fraid not Len it's way past my humble vba abilities. I was just glad it worked and raise my hat to the wonderful nerd who programmed it. Sorry I can't be more help.

 

[Len Boorman]

Thanks for you time anyway

Will have apeek and a poke and see what happens

Len

 

[BarryMK]

I found the post where I got this code from. It was posted by mrabrams2

http://www.access-programmers.co.uk/forums/showthread.php?t=50038

and he states 'Just to set the record straight, this Prevent Mouse Wheel
solution, is credited to a gentleman named Andy (Accessman) from Indiana,
with help from another nice guy from England named Rory

I'm going to pop their excellent example in the code repository and hope they would approve.
barry

 

[Len Boorman]

I am sure they would approve

 

[Len Boorman]

Looks like that code works for A97 only on Win98 or 2000

Len

 

[commandolomo]

Hey Len

I was not having a go, honest! I too am guilty (on very rare occasiosns ) of posting before searching. I was just reiterating the existance of the search facility incase you were unaware of it.

I hope that you have found a workable solution

PJL

 

[Len Boorman]

Hey Len

I was not having a go, honest! I too am guilty (on very rare occasiosns ) of posting before searching. I was just reiterating the existance of the search facility incase you were unaware of it.

I hope that you have found a workable solution

PJL

hey no problem. If I thought you were having a go I would have been a bit sharper in my reply. Yup I normally search first but was really under the cosh at the time so posted first.

Got a solution for A97 on 98/2000 thats resolved a major part but would really like a universal solution.

We have more combinations of OS and Applications than bill gates probably thinks possible and it really gives a few headaches at times.

keep smiling

L

 

[ghudson]

A Better Mouse Trap works with all versions of Access and Windows.