Solved

Block moving to next record when using mouse scrollwheel

Posted on 2004-09-07
4
321 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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

776 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