Solved

Block moving to next record when using mouse scrollwheel

Posted on 2004-09-07
4
303 Views
Last Modified: 2006-11-17
Got a stupid problem and don't know how to solve it:

When a user is filling out a form in my access data project and he uses the scrollwheel of his mouse, a new record is inserted.
Even when I set the properties of the form not to allow new records.

How can I use the scrollwheel to scroll down on the form instead of adding a new record. Is there an mousewheel event or something else that can be used to bind another action in access on the mousewheel?

thx
0
Comment
Question by:deurklink
4 Comments
 
LVL 15

Expert Comment

by:will_scarlet7
ID: 11995746
I don't know of a way to trap the mouse wheel to execute a function other that going to the next record, but you can turn the mouse wheel off for your Access database. Check out Stephen Lebans' utility for this:

http://www.lebans.com/mousewheelonoff.htm
0
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 50 total points
ID: 11995821
Access 2002 exposes the MouseWheel function, which you could use to trap the scroll ... I'm not sure if you could force the page to scroll down (your form really shouldn't require the user to scroll down/side-to-side anyway, but that's another topic) ... if you're using 2000 or 97, you'll have to use the code at the link above. There's also code on the MS site that shows how to build a .dll, but the code provided by will's link is much better, IMO.
0
 

Author Comment

by:deurklink
ID: 11996177
Scrolling down the form itself is indead not good, but it would be intresting if you could scroll down in e.g. a large input textbox.
I'd like to accept both sollutions, but I'm working in Access 2002 (access data project ;-), so LSM, thank you!
0
 

Expert Comment

by:chrisamuel
ID: 12453112
Why is it bad to scroll down a form?
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now