Solved

Block moving to next record when using mouse scrollwheel

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Field behavior for "locked" form 12 29
Sum Multiple Columns in Access Query 5 48
data analyst 3 48
Parse last 2 characters of text value if they are letters 7 15
When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

914 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

17 Experts available now in Live!

Get 1:1 Help Now