Scrolling down a form.

[Firemansam]

G'day,

I was wondering whether anyone could tell me how to make the form move up and down when using the scroll wheel on a mouse. When I use the wheel on the mouse now it scroll thru all the record entries. This is causing hassles for the users as they may accidentally enter the right info under the wrong record entry.

Thanks in advance.

 

[missinglinq]

You can only do this in Access 2007, where they finally corrected the problem. If you're using this version use Access Help to find out how to do this.

For other versions, the best you can do is to lock the mouse wheel so that it doesn't move to another record. Stephen Lebans has a sample database that does this and can be downloaded at:

http://www.lebans.com/mousewheelonoff.htm

Download and unzip the db and take a look. In your db and goto File > External Data > Import and import the module modMouseHook (I think that's the name) from the sample database.

In the first form to load in your db use this code:

Private Sub Form_Load()
   ' Turn off Mouse Scroll
    blRet = MouseWheelOFF
End Sub

 

[Firemansam]

oh well, Thanx anyway Missinglinq