If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Mouse scroll wheel with forms
I have a data-entry form that's bound to a recordset, and uses the "where"
clause to go to a required record for editing, and the "acNewRec" option when moving to a new record for data entry. However, when users scroll the mouse wheel when in the form, the form goes to a new record. This causes unwanted problems (and a lot of confusion for the users). I don't want the users scrolling to a new record when already in a record that they're editing. Note that the "Cycle" property has been set to "Current Record". Is there some way to turn off this "feature"? Or alternatively, is there some workaround? Thanks, Vilem Sova |
#2
|
|||
|
|||
Mouse scroll wheel with forms
Use the solution Stephen Lebans provides:
http://www.lebans.com/mousewheelonoff.htm Rob "Vilem Sova" wrote in message ... I have a data-entry form that's bound to a recordset, and uses the "where" clause to go to a required record for editing, and the "acNewRec" option when moving to a new record for data entry. However, when users scroll the mouse wheel when in the form, the form goes to a new record. This causes unwanted problems (and a lot of confusion for the users). I don't want the users scrolling to a new record when already in a record that they're editing. Note that the "Cycle" property has been set to "Current Record". Is there some way to turn off this "feature"? Or alternatively, is there some workaround? Thanks, Vilem Sova |
#3
|
|||
|
|||
Mouse scroll wheel with forms
The mouse wheel does not change records in Access 2007. You can still scroll
records in a continuous form or datasheet, and you can use the MouseWheel event if you want to scroll records as previous versions did, but it no longer has that annoying behavior by default. For earlier version, see: http://www.lebans.com/mousewheelonoff.htm -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Vilem Sova" wrote in message ... I have a data-entry form that's bound to a recordset, and uses the "where" clause to go to a required record for editing, and the "acNewRec" option when moving to a new record for data entry. However, when users scroll the mouse wheel when in the form, the form goes to a new record. This causes unwanted problems (and a lot of confusion for the users). I don't want the users scrolling to a new record when already in a record that they're editing. Note that the "Cycle" property has been set to "Current Record". Is there some way to turn off this "feature"? Or alternatively, is there some workaround? |
#4
|
|||
|
|||
Mouse scroll wheel with forms
Hi Vilem,
Try this excellent item from Stephen Lebans. http://www.lebans.com/mousewheelonoff.htm Damian. "Vilem Sova" wrote: I have a data-entry form that's bound to a recordset, and uses the "where" clause to go to a required record for editing, and the "acNewRec" option when moving to a new record for data entry. However, when users scroll the mouse wheel when in the form, the form goes to a new record. This causes unwanted problems (and a lot of confusion for the users). I don't want the users scrolling to a new record when already in a record that they're editing. Note that the "Cycle" property has been set to "Current Record". Is there some way to turn off this "feature"? Or alternatively, is there some workaround? Thanks, Vilem Sova |
#5
|
|||
|
|||
Mouse scroll wheel with forms
And to think, only last month I had someone take me to task when I suggested
that the most commonly used answer to this problem was Stephan's routine! It's good to know MS finally addressed the mousewheel problem, Allen, but as we all know, clients, unless they just opened for business, seldom have the latest version of Access! -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000 Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200612/1 |
Thread Tools | |
Display Modes | |
|
|