[AccessD] Scroll button

John ...

The code sent is used on a form that returns one record for
editing/updating.
The form cycle property is to current record so the user doesn't go to a new
record after finishing his updates.
The only problem that I've encountered with the mouse wheel is that the form
will go to a new record if the user accidentally moves the scroll button.
To solve this problem, the code prevents the user from going to a new record
without the need of using a dll to disable the scroll wheel.
It works for that purpose, is simple and one doesn't have to worry about
distributing and registering a dll.

Private Sub Form_Current()
        DoCmd.GoToRecord , , acFirst
End Sub

I've never had any other problems with  the scroll button. Can you give me
an example of a problem?

Thanks,
Dennis Patrino



> Message: 10
> Date: Tue, 07 Sep 2010 16:09:52 -0400
> From: jwcolby <jwcolby at colbyconsulting.com>
> Subject: Re: [AccessD] Scroll button
> To: Access Developers discussion and problem solving
>        <accessd at databaseadvisors.com>
> Message-ID: <4C869C10.4090500 at colbyconsulting.com>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> The user wants the mouse scroll to be ignored.  This seems like it would
> move to the first record
> which is not what they want.
>
> John W. Colby
> www.ColbyConsulting.com
>
> On 9/7/2010 3:20 PM, Den Patrino wrote:
> > John ...
> >
> > re - mouse scroll
> > If your concern with the mouse scroll is to prevent the user from moving
> to
> > another record on a form with the scroll button, you don't have to worry
> > about dll's etc.
> >
> > An easy solution is to:
> > Private Sub Form_Current()
> > 'This code prevents the user from moving to another record via the mouse
> > wheel button
> >      DoCmd.GoToRecord , , acFirst
> > End Sub
> >
> > Dennis Patrino
> >
> >
> > From: accessd-bounces at databaseadvisors.com [mailto:
> > accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
> > Sent: Thursday, 2 September 2010 11:57 PM
> > To: Access Developers discussion and problem solving
> > Subject: [AccessD] disable scroll wheel
> >
> > I am trying to use the archives and I am getting nothing on anything I
> > search.  Possibly down?
> >
> > Anyway, I remember a discussion about disabling the scroll wheel in
> Access.
> >   I didn't need that info
> > at the time so I just noted it in the back of my brain.
> >
> > Well now I need it.  Can anyone discuss how it is done, and at what
> level?
> >   Is it code that turns it
> > on and off?  Is it turned on in a specific form or table or in all of
> > Access?
> >
> > Thanks!
> >
> > --
> > John W. Colby
> > www.ColbyConsulting.com<http://www.colbyconsulting.com/>
>