In Microsoft Access 2003, a new feature has been added to help you determine if there are some common errors in the design view of you form. These errors are:
To see an example of the error checking in action, try the following:
After making the change, either a SmartTag will be displayed (if the button is still selected), or if you select a different control, then the upper-left hand corner of each of the button will turn a different color. Clicking on either object will open the SmartTag. If you click on the SmartTag, it will drop down a menu, and at the top of it, it states, "Keyboard Shortcut Errors".
The drawback with the feature in Access is that you need to manually open each form and see if conflicts exist.
For comprehensive documentation and analysis of your Access databases, check out our Total Access Analyzer program. Total Access Analyzer performs detailed analysis of all your Access forms to find these problems so you don't need to manually go to each one. This is just a few of the 280+ types of errors, suggestions, and performance tips Total Access Analyzer finds in your Microsoft Access databases.
Thank you! Thank you! I just finished reading this document, which was part of a link in the recent Buzz newsletter. I have printed it for others to read, especially those skeptical on the powers of Access and its capabilities.