Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms Programming / August 2005

Tip: Looking for answers? Try searching our database.

Any way to disable the mousewheel from moving to the next record (Access XP)

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Gijs Beukenoot - 24 Aug 2005 18:53 GMT
Well, the question is all in the header, is there ?

I have a bound form that jumps around the recordset if the user uses
the mousewheel. Worse, if the user accidentally hits the wheel while
moving to another tab or subform or control (not everybody knows how to
handle Windows applications with the TAB and/or ENTER key), the user
ends up editing a completely different record...
I could implement a filter (or where) so only one record is shown but
that would limit the use of certain forms where I have a next and
previous button (among first and last and some others).
I don't see any possibilities (in Access XP) to disable the mousewheel;
I can't use a cancelevent (well, I can use it but it doesn't prevent
moving to a new record) and the only thing I can come up with is
setting up some code on the Current and Dirty and MouseWheel and
BeforeUpdate that, all together, will keep the user on the same record.

Any other thoughts?

Thx,

GB
martialarts25 - 24 Aug 2005 19:11 GMT
I have the same problem in Access 2002 on Windows 2000.  Have you had any
luck since posting this message?  Do you have any work arounds?  It seems
that it would be a simple fix but have not had any luck so far.  

Thank You
martialarts25

> Well, the question is all in the header, is there ?
>
[quoted text clipped - 17 lines]
>
> GB
Dirk Goldgar - 24 Aug 2005 19:18 GMT
> Well, the question is all in the header, is there ?
>
[quoted text clipped - 12 lines]
> MouseWheel and BeforeUpdate that, all together, will keep the user on
> the same record.

Stephen Lebans has provided a solution:

   http://www.lebans.com/mousewheelonoff.htm

Signature

Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Gijs Beukenoot - 24 Aug 2005 21:43 GMT
Dirk Goldgar formuleerde de vraag :
>> Well, the question is all in the header, is there ?
>>
[quoted text clipped - 16 lines]
>
>     http://www.lebans.com/mousewheelonoff.htm

I'll have a look into that one, looks promising from what I've read on
the page.

Thanks!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.