Access 2007 scrolling with Left mouse button

[CP]

Hi, all. I have an Access application written in Access 2003 that we
are now testing with Access 2007. When using Access 2003, the users
used to be able to scroll through records displayed on a form by
positioning the cursor on top of a VCR button and holding down the
left mouse button. People with external mice could also cause the
same scrolling by using their mouse wheel. Neither of these behaviors
happen when the application is run using Access 2007.

After reading a number of posts about changing the behavior of the
mouse WHEEL when using Access 2007 so it mimics the scrolling in
Access 2003, I hoped that those changes would also cause the left
button to function similarly (I have LOTS of users with laptops &
touchpads without wheels).. I set up the DoMouseWheel function that
Allen Browne suggests in his web site but it didn't change the
behavior of my touchpad's left hand button.

Am I correct in thinking that the left-hand button on a touchpad could
mimic the wheel of an external mouse? If so, then why won't Allen
Browne's function work. If I'm incorrect, then what other options do
I have to get the left-hand mouse button to scroll through records?

Many thanks in advance. Carol.

 

[Jeanette Cunningham]

I just checked this on my laptop which has A2007 on Vista.

The left mouse scroll button the laptop did scroll the form when cursor was
over the VCR button.
The scroll part of the touchpad also scrolled the form.

Note: there is no need to use Allen's function to get the above behavior.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[CP]

Thanks, Jeanette, but the application we are testing doesn't exhibit
that behavior. Sorry I forgot to mention earlier that we are using
Access 2007 on XP machines. Maybe that makes a difference.

Carol.

 

[Jeanette Cunningham]

Did you try it after removing Allen's code?

I don't have XP on my laptop.
In the same app using A2007 on XP, holding down the left mouse button over
the VCR button does make the form scroll normally.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia



Thanks, Jeanette, but the application we are testing doesn't exhibit
that behavior. Sorry I forgot to mention earlier that we are using
Access 2007 on XP machines. Maybe that makes a difference.

Carol.

 

[CP]

Good idea about removing Allen's code, Jeanette, but it didn't make a
differerence. And the people who are testing our application have the
same problem where the left mouse button doesn't cause the VCR buttons
to scroll.

Other ideas? Carol.

 

[Jeanette Cunningham]

Are you finding that even when using a mouse (not a touch pad) that holding
down the left mouse button on the down arrow at bottom of a scrollbar on a
continuous form won't cause the form to scroll to the bottom?
Can you confirm that scrolling your app on a computer with a mouse -- you
are unable to scroll while holding down the arrow at either the top or
bottom of the scrollbar on a continuous form.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia


Good idea about removing Allen's code, Jeanette, but it didn't make a
differerence. And the people who are testing our application have the
same problem where the left mouse button doesn't cause the VCR buttons
to scroll.

Other ideas? Carol.

 

[CP]

Sorry but I don't have a mouse for my laptop, Jeanette, but I've asked
one of my testers to test this with her desktop that does have an
actual mouse.

Also, given your question I did some more tests which gave what I
think are important results:

1. The form we've been working with doesn't actually have scroll bars
but I added them (through Form Properties) and WAS ABLE TO SCROLL
through the records using the scroll bars up and down arrows and
holding the left button of my touchpad's mouse down. VCR buttons
still didn't work.
2. The application has another form that does have scroll bars and I
was also able to scroll through the records shown on this form by
using the bars. BUT I still wasn't able to use the VCR buttons and my
left mouse button to scroll through the records.

I also tried this in a plain vanilla Access database that I created in
Access 2007 and found the same characteristics. So this looks like
something in Access itself, not in my specific application.

I'll keep looking. Thanks for your help. Carol.

 

[Jeanette Cunningham]

And now I understand what you mean when you write 'VCR' buttons.
Yes, the no repeat when holding the vcr buttons is part of A2007.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia


Sorry but I don't have a mouse for my laptop, Jeanette, but I've asked
one of my testers to test this with her desktop that does have an
actual mouse.

Also, given your question I did some more tests which gave what I
think are important results:

1. The form we've been working with doesn't actually have scroll bars
but I added them (through Form Properties) and WAS ABLE TO SCROLL
through the records using the scroll bars up and down arrows and
holding the left button of my touchpad's mouse down. VCR buttons
still didn't work.
2. The application has another form that does have scroll bars and I
was also able to scroll through the records shown on this form by
using the bars. BUT I still wasn't able to use the VCR buttons and my
left mouse button to scroll through the records.

I also tried this in a plain vanilla Access database that I created in
Access 2007 and found the same characteristics. So this looks like
something in Access itself, not in my specific application.

I'll keep looking. Thanks for your help. Carol.

 

[CP]

Ugh. So does that mean that Allen Browne's method for reinstating
the use of the mouse wheel in Access 2007 won't help my problem? ;-(

Does anyone know of any other options?

Carol.

 

[CP]

Guess I can just add Scroll Bars to the form and the users can scroll
through the records using them.

Thanks for all your help, Jeanette.

Carol.