In this article we look at key mistakes one needs to avoid while designing forms in Ms Access, especially if you prefer to design forms manually instead of using a Wizard.
If you are using Ms Access it is quite logical that now or later you would need to design forms. In this article we show you how easy it is to create forms in Ms Access. One of the most commonly used features of MS Access is AutoForm. A lot of different types of forms can be created with the help of the AutoForm Wizard. However if you are not using AutoForms and are instead creating a form manually, you have to make sure that it is free of errors. A lot of the time a user is not able to completely utilize forms to their potential because they end up making lots of mistakes and errors while creating a form. A lot of those errors can be done away with in case of AutoForms, but with manual forms you need to be extra careful to avoid the following common errors.
1. Verification of Data Sources:
While creating a form it is important to ensure that all the tables and queries being used are valid. Check all the row and record sources of the form, for all combo and list boxes.
2. Make Use of Captions
If you do not set the ‘Caption Property’ for the form, you can’t complain later about seeing an unwanted title on the form.
3. Avoid Duplicate Hotkeys
The Accelerator Keys or the Hotkeys should not be duplicated. It is because of the Accelerator keys that ‘Alt’ + a key shortcut is possible. Verify all hotkeys in the form before assigning them a control.
4. Verification of Tab Order
All the controls should have a correct tab order, the default settings of a tab order are always left to right and top to bottom. Any kind of diversion from this pattern might result in unfavorable user behavior. You can set the default tab order in View < Tab Order Menu.
5. Set Allowed Views
The Allowed Views should be assigned to show users only what you want them to see, in the way you want to them to see. A choice can be made from Datasheet View, Form View, etc.
6. Prevent Missing Code
Every event assigned [Event Procedure], should have a well defined event procedure. It is common to assign an event without an actual written code.
7. Set AutoCenter
The AutoCenter Property should be set to “Yes”. This property ensures that every time the form is opened, it remains in the center of the screen irrespective of its position at the time of designing the form or the resolution of user’s screen.
8. Set Resize Property
To make sure that the form you designed opens up in the size you designed it in, set the Auto Resize Property to Yes. If it is set to No, the form will appear in the size it was last saved in.
An Ms Access Crash can Compromise the Painstakingly Designed Custom Forms
In case your Ms Access database topples over, the crash would not only compromise all the data stored in the database but Custom Forms too which may designed with lot of effort. To save your data from such a situation, you need to swiftly run a recover mdb tool which can bring back all your data elements. However before choosing any tool, make it a point to check if it can recover large Ms Access files and also consider its capacity to handle different media types.
Vivian Stevens is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including repair mdf data damage and excel recovery software products. For more information visit www.datanumen.com