Microsoft KB Archive/255666

{|
 * width="100%"|

ACC2000: Save Record Command Is Not Available When You Set AllowEdits Property to No

 * }

Q255666

-

The information in this article applies to:


 * Microsoft Access 2000

-

Novice: Requires knowledge of the user interface on single-user computers.

This article applies to a Microsoft Access database (.mdb) and a Microsoft Access project (.adp).

SYMPTOMS
The Save Record command on the Records menu is not available (it is dimmed). You cannot use the command to save a new record.

CAUSE
Microsoft Access 2000 does not check the setting of the AllowAdditions property of the form. Access just checks the underlying state of the AllowEdits property. If the AllowEdits property is set to No, the Save Record command is not available.

RESOLUTION
To work around this behavior, move to a new or to an existing record. This will save the new record. To move to a new or to an existing record, use the record navigation buttons. You can also point to Go To on the Edit menu, and click one of the following commands: 

First

Last

Next

Previous

New Record

STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

MORE INFORMATION
In earlier versions of Microsoft Access, when you set AllowEdits property to No and the AllowAdditions property to Yes, you can still enter a new record, and then save the record by using the Save Record command. In Access 2000, however, you cannot do this.

Steps to Reproduce Behavior

 * 1) Open the sample database Northwind.mdb.
 * 2) In the Database window, click Forms, right-click the Customers form, and then click Design View.
 * 3) On the View menu, click Properties.
 * 4) Click the Data tab, and then set the AllowEdits property to No.
 * 5) On the View menu, click Form View.
 * 6) On the Edit menu, point to Go To, and then click New Record.
 * 7) In the new record, type the following data:
 * 8) Click the Records menu. Note that the Save Record command is not available.

NOTE: Because the Save Record command is not available, code that tries to save the record is not successful. For example:

DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord,, acMenuVer70 or

DoCmd.RunCommand acCmdSaveRecord If you run this code, you will receive the following error message:

The command or action 'SaveRecord' isn't available now.