Editors & Tools Miscellaneous

The Access Forms and Reports Assistant (AFRA) is a batch form and report property and font changing utility for Access developers. It will run with Access 2000, 2002, or 2003, and make changes to any of those three Access mdb files for which you have the appropriate Access version installed on your computer. If you work with several secured databases, AFRA can keep track of your security information so you just select the workgroup data with two mouse clicks. All writeable form and report properties for Access 2000, 2002, and 2003 are available except the HasModule property (that one could be a disaster, erasing all your form and report module code in an instant). AFRA detects the version of Access your mdb file was created in and displays only those properties suitable to your database. All properties that have standard entries (other than text, command bar names, or code) are available from a drop-down list. You may select Design View Only for the AllowDesignChanges property but AFRA enters the required value of True for this entry (since it is being changed in VBA and not on the form's property sheet). Once you execute, Access automation opens your database and makes the changes.