?
Solved

Block moving to next record when using mouse scrollwheel

Posted on 2004-09-07
4
Medium Priority
?
357 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 85

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 150 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

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

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

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

864 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