Link to home
Start Free TrialLog in
Avatar of SweetingA
SweetingA

asked on

Scrolling Records

I have a very large frm with thousands of pictures attached.
On accasion, if i scroll through the records too quickly the db will crash.
Is there a way to slow down the rate users can search through the records.

Disable mouse scroll botton and program delay after each press of record select?
Avatar of rockiroads
rockiroads
Flag of United States of America image

why have it setup like that? could you not have a link or button on your form that shows the picture if and when required?
disabling mouse scroll  sample code can be found here http://www.vbaexpress.com/kb/getarticle.php?kb_id=890
Avatar of SweetingA
SweetingA

ASKER

The code won't compile

Their are too lines in red.....

Public Const GWL_WNDPROC = -4
Public Const WM_MouseWheel = &H20A
ASKER CERTIFIED SOLUTION
Avatar of rockiroads
rockiroads
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I have decided to share the points - both solutions work but i have to say the second is much easier.

Thanks