how can I disable the mouse Scrolling Wheel?

[GGerard]

Hello

I have an Access 2000 form with the following properties:

Record Source - Table1

Allow Additions - Yes

Data Entry - Yes

Cycle - Current Record

When I open this form the underlying table (Table1) goes to a new record
(let's call it record 1) as it should.

After typing in some data in this new record (record 1), if I turn the mouse
scrolling wheel, the underlying table then moves to the next new record
(record 2) and all the data appearing on the form disappears since the form's
controls (all the text boxes) are also bound to Table1.

If I start typing in data in this new record (record 2) and then turn the
mouse scrolling wheel again, Table1 moves to another new record (record 3)
and so on.

So is there a way to stop this from happening either by disabling the mouse
scrolling wheel or by some other way?

Thanks

G.Gerard

[Douglas J. Steele]

Take a look at what Stephen Lebans has at
http://www.lebans.com/mousewheelonoff.htm

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"GGerard" <gg*****@nbnet.nb.ca> wrote in message
news:qI*********************@ursa-nb00s0.nbnet.nb.ca...

So is there a way to stop this from happening either by disabling the
mouse scrolling wheel or by some other way?

[accesspro4u]

>> So is there a way to stop this from happening >> either by disabling the mouse

scrolling wheel or by some other way?

Gerard,
I tried the .dll route before, and it worked just fine at home, but
when I tried to implement it at work, my app crashed. It was because
they used different mice at work, with different drivers...I couldnt
install the recommended drivers, because they used a USB connection and
required a different driver.. MS has a different option, that will
prevent the mouse scroll without using a custom .dll... the only caveat
is, you can not open the visual basic editor in the production app or
MS Access will hang... this shouldnt be a problem if users are running
a run-time version.. if not, then make sure to do your development work
in a copy of the production database, then switch copies when needed...
see the following link for more info:

http://support.microsoft.com/default...b;en-us;278379
Mark
ac*********@aol.com

[Stephen Lebans]

There is absolutely no way that my MouseHook DLL could cause your app to
crash. The code simply discards specific MouseWheel messages...nothing
else, period. For you to state otherwise shows your lack of
understanding in this area.

--
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
<ac*********@aol.com> wrote in message
news:11**********************@g44g2000cwa.googlegr oups.com...

So is there a way to stop this from happening >> either by disabling the mouse scrolling wheel or by some other way?

Gerard,
I tried the .dll route before, and it worked just fine at home, but
when I tried to implement it at work, my app crashed. It was because
they used different mice at work, with different drivers...I couldnt
install the recommended drivers, because they used a USB connection

and required a different driver.. MS has a different option, that will
prevent the mouse scroll without using a custom .dll... the only caveat is, you can not open the visual basic editor in the production app or
MS Access will hang... this shouldnt be a problem if users are running
a run-time version.. if not, then make sure to do your development work in a copy of the production database, then switch copies when needed...

see the following link for more info:

http://support.microsoft.com/default...b;en-us;278379
Mark
ac*********@aol.com

[Lauren Wilson]

On Sat, 25 Jun 2005 16:45:14 -0400, "Douglas J. Steele"
<NOSPAM_djsteele@NOSPAM_canada.com> wrote:

Take a look at what Stephen Lebans has at
http://www.lebans.com/mousewheelonoff.htm

This reminds me: Does anyone know why the mouse wheel will not work
inside the VBA editor? It works in most other places in Access but
not there. Makes no sense to me.

[Rick Brandt]

"Lauren Wilson" <no****@private.com> wrote in message
news:sa********************************@4ax.com...

On Sat, 25 Jun 2005 16:45:14 -0400, "Douglas J. Steele"
<NOSPAM_djsteele@NOSPAM_canada.com> wrote:

Take a look at what Stephen Lebans has at
http://www.lebans.com/mousewheelonoff.htm

This reminds me: Does anyone know why the mouse wheel will not work
inside the VBA editor? It works in most other places in Access but
not there. Makes no sense to me.

It's mouse driver sensitive. I had to "downgrade" several versions of my mouse
intellimouse driver to get scrolling in the vba window to work.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

[Trevor Best]

Rick Brandt wrote:

"Lauren Wilson" <no****@private.com> wrote in message
news:sa********************************@4ax.com...

On Sat, 25 Jun 2005 16:45:14 -0400, "Douglas J. Steele"
<NOSPAM_djsteele@NOSPAM_canada.com> wrote:

Take a look at what Stephen Lebans has at
http://www.lebans.com/mousewheelonoff.htm

This reminds me: Does anyone know why the mouse wheel will not work
inside the VBA editor? It works in most other places in Access but
not there. Makes no sense to me.

It's mouse driver sensitive. I had to "downgrade" several versions of my mouse
intellimouse driver to get scrolling in the vba window to work.

Yeah, Intellipoint 4 works in the VBA window but 5 does not.

Alternatively there's freewheel
http://www.geocities.com/SiliconVall...freewheel.html

--
[OO=00=OO]