Microsoft Access Help
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
Go Back   ASP Free ForumsDatabaseMicrosoft Access Help

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread ASP Free Forums Sponsor:
  #1  
Old June 22nd, 2008, 08:36 PM
darryl darryl is offline
Registered User
ASP Free Newbie (0 - 499 posts)
 
Join Date: Nov 2007
Posts: 8 darryl User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 h 50 m 11 sec
Reputation Power: 0
Forms - Disabling Mouse Wheel Scroll in Access

I created a database whose data is entered onto a form by the users. The problem with the database is---when the user navigates down the form using the mouse wheel scroll the records change without the user realizing it. Does anyone know how to disable the mouse wheel scroll function in a database so as to prevent inadvertent entry of data to the wrong record?

I've seen/heard there are VB solutions, all of which sound/read like Greek to me. Has anyone stumbled onto a solution that someone with moderate Access skills might be able to implement?

Reply With Quote
  #2  
Old June 22nd, 2008, 09:58 PM
sbenj69's Avatar
sbenj69 sbenj69 is offline
Redneck 'puter fell'r
ASP Free Intermediate (1500 - 1999 posts)
 
Join Date: Feb 2007
Location: Redneck part of Illinois
Posts: 1,722 sbenj69 User rank is General 7th Grade (Above 100000 Reputation Level)sbenj69 User rank is General 7th Grade (Above 100000 Reputation Level)sbenj69 User rank is General 7th Grade (Above 100000 Reputation Level)sbenj69 User rank is General 7th Grade (Above 100000 Reputation Level)sbenj69 User rank is General 7th Grade (Above 100000 Reputation Level)sbenj69 User rank is General 7th Grade (Above 100000 Reputation Level)sbenj69 User rank is General 7th Grade (Above 100000 Reputation Level)sbenj69 User rank is General 7th Grade (Above 100000 Reputation Level)sbenj69 User rank is General 7th Grade (Above 100000 Reputation Level)sbenj69 User rank is General 7th Grade (Above 100000 Reputation Level)sbenj69 User rank is General 7th Grade (Above 100000 Reputation Level)sbenj69 User rank is General 7th Grade (Above 100000 Reputation Level)sbenj69 User rank is General 7th Grade (Above 100000 Reputation Level)sbenj69 User rank is General 7th Grade (Above 100000 Reputation Level)sbenj69 User rank is General 7th Grade (Above 100000 Reputation Level)sbenj69 User rank is General 7th Grade (Above 100000 Reputation Level)  Folding Points: 305646 Folding Title: Super Ultimate Folder - Level 1Folding Points: 305646 Folding Title: Super Ultimate Folder - Level 1Folding Points: 305646 Folding Title: Super Ultimate Folder - Level 1Folding Points: 305646 Folding Title: Super Ultimate Folder - Level 1Folding Points: 305646 Folding Title: Super Ultimate Folder - Level 1Folding Points: 305646 Folding Title: Super Ultimate Folder - Level 1
Time spent in forums: 3 Weeks 1 Day 13 h 17 m 38 sec
Reputation Power: 1460
You can try this:

Disable Mouse Scroll
Comments on this post
Mattwesterville agrees: Looks like a better scroll-killer than mine, ez too.
__________________
Did I help you? If so gimme rep by clicking on the scales at the top right corner of this post

Madness does not always howl. Sometimes, it is the quiet voice at the end of the day saying, "Hey, is there room in your head for one more?"

Reply With Quote
  #3  
Old June 20th, 2009, 09:32 AM
darryl darryl is offline
Registered User
ASP Free Newbie (0 - 499 posts)
 
Join Date: Nov 2007
Posts: 8 darryl User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 h 50 m 11 sec
Reputation Power: 0
Disabling Mouse Wheel Scroll in Access

Quote:
Originally Posted by sbenj69
You can try this:

Disable Mouse Scroll


Just not working for me. Below is what I'm getting when I use a code given to me by someone else. It also required using a dll file which I'm also putting in the folder with the db.

Private Sub Form_Open(Cancel As Integer)
DoCmd.Maximize
'This piece of code can be added to a button or you can leave here
'Darryl Johnson 6/22/09
'Private Sub Command14_Click()
' Turn the MouseWheel Off
' Turn the MouseWheel Off
Dim blRet As Boolean
' Call our MouseHook function in the MouseHook dll.
' Please not the Optional GlobalHook BOOLEAN parameter
' Several developers asked for the MouseHook to be able to work with
' multiple instances of Access. In order to accomodate this request I
' have modified the function to allow the caller to
' specify a thread specific(this current instance of Access only) or
' a global(all applications) MouseWheel Hook.
' Only use the GlobalHook if you will be running multiple instances of Access!
blRet = MouseWheelOFF(False)
End Sub

Error message is

Microsoft Visual Basic

Compile error:

Sub Function not defined

I just don't know why this wont work now - especially after having used it successfully in another db. Would it have anything to do with copying that dame dll file?

Reply With Quote
Reply

Viewing: ASP Free ForumsDatabaseMicrosoft Access Help > Forms - Disabling Mouse Wheel Scroll in Access


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump



 Free IT White Papers!
 
How to Present Effectively Online
This white paper offers practical and actionable advice on the key steps that any presenter should consider as they plan and execute a Webinar or online meeting.

 
Open Source Security Myths
Open Source Software (OSS) is computer software whose source code is available to the general public with relaxed or non-existent intellectual property restrictions (or arrangement such as the public domain), and is usually developed with the input of many contributors.

 
Power and Cooling Capacity Management for Data Centers
This paper describes the principles for achieving power and cooling capacity management.

 
Scalable, Fault-Tolerant NAS for Oracle - The Next Generation
For several years NAS has been evolving as a storage alternative for Oracle databases, and for good reason: NAS is quite often the simplest, most cost-effective storage approach for Oracle. Learn about the benefits that HP's approach to scalable NAS brings to Oracle environments in this comprehensive white paper.

 
Understanding Web Application Security Challenges
This white paper discusses many common threats and preventive measures for Web application security, and explains what you can do to help protect your organization.

 

Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2009 by Developer Shed. All rights reserved. DS Cluster 4 hosted by Hostway
Stay green...Green IT