A slightly different Mouse Wheel problem

[LBitner99]

Howdy all,

I couldnt seem to find this anywhere else so i hope someone can help me.


I know there are lots of ways to get the mouse wheel disabled in access.. I've used the code in several other databases.. but what i need is to change the behavior.. I need the mousewheel to scroll through the form window (up and down) but not change records.. i just want it to do what it does in any other program which is just merely scroll up and down on the page? any ideas?

 

[ghudson]

If your form is that big then you should consider using tabs in your form. Your users will also appreciate your effort to reduce the amout of scrolling they have to do just to navigate your form.

 

[LBitner99]

The problem being that there isnt a good way to break up the form to do so... that and teaching my users to click on tabs instead of scrolling is needless to say a fruitless venture... trust me

 

[LBitner99]

Does anyone out there have an idea?

 

[ghudson]

You can set the forms "Cycle" property to Current Record. That will prevent the mouse wheel from scrolling through the records and instead move the form up or down with the mouse wheel.

If your form is that big then you should consider redesigning it [breaking it up]. Your users will thank you for it. Out of curiosity, can you post a snapshot [bmp, jpg] of your form in question.

 

[LBitner99]

well the cycle property change didnt seem to work.. it stopped the mouse wheel but didnt move the window at all... oh well.. ill just disable it and be done.

 

[ghudson]

It should work if the form [or any object on the form] in question has the focus. Do you have any code running that would keep the focus off of the form? A quick test would be to click in a text box and then use the mouse wheel to scroll up and down the form. The form should move up or down if the form is longer that the window size of the form.

 

[ImLost]

This is something I need, too, but the cycle suggestion isn't working. In the events for On Current I have a maximize macro, would that be keeping the focus off the form? I don't really know VBA at all, so I hope there's something I can do outside of that.

It's not that the form is lengthy, but sometimes I need to minimize the window and work with two windows (programs) at once; researching data in one and typing it into the database. Being able to scroll would be very nice instead of needing to rely on the tab key.

 

[prometro]

MouseWheel in SubForms problem - solution

I think I found some solution. I send to you file where I set this parameters :

(sorry my english - and terminology (i have other language and try to translate))

In TextBox in Subform I set in the Events : OnExit.....Macro
In Macro I set action "CancelEvent"
It disable MouseWheel in Subform TextBoxes.

I think it is working perfect. I hope that there is no other problem with using this. What do you think?
Jirka

 

[prometro]

I forget...file