Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Mouse wheel does not work properly in forms of Access 2007

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 30-11-2010
Member
 
Join Date: Nov 2010
Posts: 33
Mouse wheel does not work properly in forms of Access 2007
  

I presently upgraded from Office XP. In this program, rolling my mouse wheel enthused through the records being viewed in my form. How do I set in motion the mouse wheel to perform this in Access 2007? I got as far as form properties or Expression Builder but did not discover what I was appearing for. So please someone provide me this and also help me to know about why this may occur.

Reply With Quote
  #2  
Old 30-11-2010
Member
 
Join Date: May 2008
Posts: 860
Re: Mouse wheel does not work properly in forms of Access 2007

The mouse scroll wheel performance was deliberately distorted in Access 2007 to decrease user confusion. In earlier versions, there were examples where the scroll wheel would scroll the scroll bar and others where it would find the way records. The scroll wheel performance is at the present reliable and only scrolls the scroll bar. There is no property to alter this behavior. In addition, there were a lot of, many queries about how to put out of action the mouse wheel performance for forms which led to this choice. Users can include in their Access applications to turn it off.
Reply With Quote
  #3  
Old 30-11-2010
Member
 
Join Date: May 2008
Posts: 913
Re: Mouse wheel does not work properly in forms of Access 2007

I have some code which may help you to sort out your mouse wheel problem in Access 2007. Just insert the following code to the form?s On Mouse Wheel event procedure:
Code:
Private Sub Form_MouseWheel(ByVal Page As Boolean, ByVal Count As Long) 
  If Not Me.D Then 
      If (Count < 0) And (Me.CR > 1) Then 
          DoCmd.GoToRecord , , acPrevious 
      ElseIf (Count > 0) And (Me.CR <= Me.Recordset.RecordCount) Then 
          DoCmd.GoToRecord , , acNext 
      End If 
  Else 
      MsgBox "The record has distorted. Save the present record earlier than moving to an additional record." 
  End If 
End Sub
You will have to regulate the code over if your form does not permit additions or is read only. It presumes you can scroll to a new record. You would only require regulating the state in the Else If statement. If the record has been restructured, you will likely wish to force the user to save the record sooner than scrolling. That was one of the major causes for this alters. Users would scroll the mouse wheel and automatically and without warning save their changes to their record.
Reply With Quote
  #4  
Old 30-11-2010
Member
 
Join Date: Nov 2008
Posts: 1,054
Re: Mouse wheel does not work properly in forms of Access 2007

I cannot scroll through records like I was earlier allowable to in Access 2003; the mouse wheel has no function in 2007. While I attempted to make use of the over recommendation to enter the code into the event of "on MouseWheel" I establish that "on mousewheel" was not a choice. I have "On Mouse Up", "On Mouse Down", "On Mouse Move" and that is it. I have seemed all through and it is just not there. If there is a method for me to generate it and after that input the event code that would be immense.
Reply With Quote
  #5  
Old 30-11-2010
Member
 
Join Date: May 2008
Posts: 979
Re: Mouse wheel does not work properly in forms of Access 2007

The scroll wheel has been operational astonishingly or wonderfully for my system which is as stated underneath in access 2007 though, I have a few users which have been updated and are still by means of 2003. At the moment the trouble for the users by means of 2003 is while they make use of the scroll wheel it goes through two records in its place of one. Is there a method to fix this for them or will they have to deal with it awaiting they do get updated.
Reply With Quote
  #6  
Old 30-11-2010
Member
 
Join Date: Nov 2008
Posts: 996
Re: Mouse wheel does not work properly in forms of Access 2007

My most excellent guess is that because the mouse wheel performance is dissimilar between the versions, 2007 requirements the code sergioKomic added above and 2003 does not require the code. My suggestion would be to contain two separate front ends, one for your 2003 users and another for your 2007 users. If that is not an alternative or choice, I would say annoying to obtain all users on the similar version of Access would be the most excellent resolution.
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Mouse wheel does not work properly in forms of Access 2007"
Thread Thread Starter Forum Replies Last Post
Elantech touchpad not working properly as ?ImPS/2 Logitech Wheel Mouse? in ubuntu Triple H Operating Systems 7 19-12-2011 10:46 PM
Middle mouse wheel button does not open tab properly in Firefox 4 Abjawadi Technology & Internet 4 24-03-2011 07:48 PM
scroll with mouse wheel does not work only in Office 2007 CostasD MS Office Support 4 09-11-2010 03:50 AM
How to Automatically access the fields of an Access 2007 forms Corona Software Development 3 25-06-2009 12:54 PM
Mouse Scroll Wheel ignored by Office 2007 Indragop Office Setup 5 19-09-2008 12:21 PM


All times are GMT +5.5. The time now is 02:19 PM.