Wednesday, August 12, 2009

A new method for disabling the Mouse Scroll Wheel in Access forms

- without needing a DLL and without VBA subclassing

This solution is being provided for free and you can use this solution in your applications freely provided you leave the copyright notices in place in the source code.

In Access versions prior to v2007, when you use the mouse scroll wheel on a form, Access will always cycle through the current records in your forms dataset. This is quite an annoyance when you might not want this behaviour, and Microsoft never offered a simple solution to turn this feature off (until v2007).

Read the full article for my unique solution.

Monday, August 10, 2009

Data Modeling for the Access Newcomer, Part 2

Last month, Glenn Lloyd started outlining his approach to data modeling. This month, he finishes his discussion of the rules that ensure that your database will actually work after you've built it. Read more