access course london - preventing users scrolling throu
The UK's Number 1 for Microsoft Office Training
Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » access course london - Preventing users scrolling through records using the mouse.

Recommend training98.1 %
recommend us
More live stats...

The UK's most regular
instructor-led training courses.

Training information:

See also:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

See also:
Hints and tips
Forum topics

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

access course london - Preventing users scrolling through records using the mouse.

resolvedResolved · Low Priority · Version Standard

replyReply Wed 13 Jun 2007, 13:51Delegate Hannah said...

Hannah has attended:
Access Advanced course

Preventing users scrolling through records using the mouse.

I have a database that is used by a number of users for data entry. There is VBA sitting behind the form to validate the information that is entered, but if users use the scroll on the mouse they can move between records and the validation does not apply. Is there any way that i can get around this?

Thank you.

For upcoming training course dates see: Pricing & availability

replyReply Tue 19 Jun 2007, 12:10Trainer Richard said...

RE: Preventing users scrolling through records using the mouse.

You could use a bit of code to switch off the Mouse Scroll Wheel:

Take a look at:

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

http://www.utteraccess.com/forums/showflat.php?Cat=&Board=83&Number=1231540&Zf=&Zw=cycle%20mouse%20wheel&Zg=0&Zl=a&Main=1231534&Search=true&where=&Zu=64822&Zd=g&Zn=&Zt=1&Zs=b&Zy=#Post1231540&Zp=

 

Access articles

· Discover The Top Ten Changes In Access 2010
· A Quick Intro On How Access Uses SQL
· Microsoft Access, an Efficient Database Tool
· How To Import Data Easily Into Access 2010
· What You Need To Know About New Security Features In Access 2007

Access tip:

Switchboard Startup

An option when you open your Access database that contains all of you tables, forms and queries is only the switchboard is displayed.

To achieve this, select Tools click on Startup. On the right hand side of the Startup screen you are able to select which form you want to open when you open you Access Database. Once you have selected this, there is a check box just below that says "Display Database Window", you need to uncheck this option. Then click ok.

Then when you close you Access database and re open it, the database should open with just the switchboard being shown


View all Access hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. infomst
All prices offered for business users and exclude VAT. E&OE · Terms & conditions · Privacy policy