I'm trying to use your mousehook off...and thanks so much... it's such
a blessing that you share with the rest of us. I have the dll in the
same folder as the database and placed the button code in the load
event of the home page. When I leave the home page and go into other
forms, the scroll still moves the user into another record. Do I need
to put the code in the load event of every form and subform where I
don't want the scroll to work? I only have access opened once, a
front end. I import the module, just as it was. Help... I'm still
learning how functions work, am I doing something wrong. I'm using
Access XP.
Thanks for your time and attention.
Debbie

You only call the MouseWHeelOff function ONCE from the Load event of any
SINGLE form and then turn it back on from the UnLoad event of that same
form.

What do you mean the Load event of the Home page? The MouseHook DLL will
not work with DAP's.

--

HTH
Stephen Lebanshttp://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Debbie" <de****@seaportnet.com> wrote in message
news:e5**************************@posting.google.c om...

Hi Stephen,

I'm trying to use your mousehook off...and thanks so much... it's such a blessing that you share with the rest of us. I have the dll in the same folder as the database and placed the button code in the load event of the home page. When I leave the home page and go into other forms, the scroll still moves the user into another record. Do I need to put the code in the load event of every form and subform where I don't want the scroll to work? I only have access opened once, a front end. I import the module, just as it was. Help... I'm still learning how functions work, am I doing something wrong. I'm using Access XP. Thanks for your time and attention. Debbie

Thanks so much for your quick reply. I'm sorry for the confusion
about the home page... it's just a lookup form with a subform that
list and sorts the records... it remains open all the time so I put
your function on the load. Now I'll go put it on the load of every
form that I don't want the scroll to work. Is there a problem if I
don't unload the home page and I call your function for other forms as
I load them?
Thanks again for your continued support.
Debbie
PS I'm moving and my DSL will go down sometime today, so if I don't
reply for a few days you won't think I'm ignoring you.

I told you to place the call to MouseWheelOff in the Load event of a
SINGLE form not every form!!!!!!!!
The MousxeHook download page and the sample MDB states/shows that a
SINGLE call to MouseWHeelOff will handle all open forms in your
application.

Before your application closes it should call MouseWheelOn.

--

HTH
Stephen Lebanshttp://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Debbie" <de****@seaportnet.com> wrote in message
news:e5**************************@posting.google.c om...

Thanks so much for your quick reply. I'm sorry for the confusion about the home page... it's just a lookup form with a subform that list and sorts the records... it remains open all the time so I put your function on the load. Now I'll go put it on the load of every form that I don't want the scroll to work. Is there a problem if I don't unload the home page and I call your function for other forms as I load them? Thanks again for your continued support. Debbie PS I'm moving and my DSL will go down sometime today, so if I don't reply for a few days you won't think I'm ignoring you.

It's me again.... I'm trying to make this work ...so I went back and
re-read your website and I'm confused (ignorant). I have subforms
that I don't want the mouse scroll to work. I have placed your
function in the load and unload of the subform and then tried it just
on the main form
load event: blRet = MouseWheelOFF
unload event: blRet = MouseWheelON
the subform still scrolls. I also have a main form with a tab control
and each tab has a subform, same thing is happening there. I'm
thinking now as I look at all these sub forms that some of the
subforms I don't need and I may have to move the subform fields to the
main form and then the mouse off will work, cause it works on the main
forms, just not the subforms.
Is it true that the mouse off won't work on subforms? Maybe it won't
work on sub forms that should have never been created...? (My
ignorance is showing for sure now)
thanks and sorry for the multiple posts... I rushed the first one
knowing my dsl is going down sometime today.
Debbie

The MouseHook processes the MouseWheel messages for SuForm controls that
have a Visible ScrollBar. In other words the MouseWheel still works for
SubForms as this is the behaviour requested by the majority of users.
WHy is this an issue for you?

--

HTH
Stephen Lebanshttp://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Debbie" <de****@seaportnet.com> wrote in message
news:e5**************************@posting.google.c om...

It's me again.... I'm trying to make this work ...so I went back and re-read your website and I'm confused (ignorant). I have subforms that I don't want the mouse scroll to work. I have placed your function in the load and unload of the subform and then tried it just on the main form load event: blRet = MouseWheelOFF unload event: blRet = MouseWheelON the subform still scrolls. I also have a main form with a tab control and each tab has a subform, same thing is happening there. I'm thinking now as I look at all these sub forms that some of the subforms I don't need and I may have to move the subform fields to the main form and then the mouse off will work, cause it works on the main forms, just not the subforms. Is it true that the mouse off won't work on subforms? Maybe it won't work on sub forms that should have never been created...? (My ignorance is showing for sure now) thanks and sorry for the multiple posts... I rushed the first one knowing my dsl is going down sometime today. Debbie

I have a form that is suppose to only show one new record. This main
form is set for data entry. The main form has a tab control on it
with several tabs..the tabs are types of people associated with this
account. On the tab for main person, there can only be one. If a
user starts to enter a main user then touches their mouse scroll it
looks like they haven't entered the main person, so they start
entering another main person. This is because the mouse scroll
advanced it to a new person record. Two main people makes a mess. I
only put the mouse hook on one form at a time I just wanted you to
know that I had tried putting it on the main form and on the subform
on the tab. In trying to use the mouse hook I did realize that it's
working on the main form but not on the sub form... I also realized
that I don't need a subform for the main person since there is only
one per case, so I'm probably need to completely re-work this form,
just didn't want to do that if not necessary. Wanted to make sure
that I was understanding what you were saying and what I was reading
on your website. I really appreciate you taking this much time with me
and I appreciate that most people would want the subform to scroll.
I'm not suggesting that you build it any other way then the way it
works now. Me building better forms, using more indexes and using your
function should accomplish what I need.
Thanks again for helping so many of us.
Debbie

The MouseHook processes the MouseWheel messages for SuForm controls that have a Visible ScrollBar. In other words the MouseWheel still works for SubForms as this is the behaviour requested by the majority of users. WHy is this an issue for you?

--

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