Microsoft KB Archive/142185

= ACC: Preventing Users from Adding New Records (95/97) =

Article ID: 142185

Article Last Modified on 1/19/2007

-

APPLIES TO


 * Microsoft Access 95 Standard Edition
 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q142185





SUMMARY
Microsoft Access 7.0 and 97 have several new properties that give developers control over forms used for data entry. One of these properties is the AllowAdditions property. Developers can use this property to determine whether users can or cannot add new records to the underlying table.



MORE INFORMATION
You can set the AllowAdditions property under the Data tab of the form's property sheet. The default setting is Yes (True or -1) and allows the user to add new records. If you set this property to No (False or 0), the user cannot add new records. The No setting disables the New Record indicator on the toolbar and the Data Entry command on the Records menu.

The following example demonstrates how the AllowAdditions property works.

CAUTION: Following the steps in this example will modify the sample database Northwind.mdb. You may want to back up the Northwind.mdb file or perform these steps on a copy of the Northwind database.


 * 1) Open the sample database Northwind.mdb.
 * 2) Open the Customers form in Form Design view.
 * 3) If the property sheet is not displayed, on the View menu, click Properties to display the form's property sheet.
 * 4) In the Form property sheet, click the Data tab and set the AllowAdditions property to No.
 * 5) Add a command button to the Customers form. Set the command button's OnClick property to [Event Procedure], and then click the Build button to the right of the OnClick property box.
 * 6) Type the following statement in the Form_Customers module:

Forms!Customers.AllowAdditions = True
 * 1) Close the Form_Customers module and save the Customers form.
 * 2) Open the Customers form in Form view. Note that Record on the Insert menu and the New Record selector are disabled. You cannot add any records. However, if you click the command button, note that the new record options are enabled.

