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
- Open the sample database Northwind.mdb.
- In the Database window, click Forms, right-click the Customers form, and then click Design View.
- On the View menu, click Properties.
- Click the Data tab, and then set the AllowEdits property to No.
- On the View menu, click Form View.
- On the Edit menu, point to Go To, and then click New Record.
- In the new record, type the following data:
- 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.
REFERENCES
For more information about the AllowEdits or AllowAdditions properties, place your mouse pointer on one of the property names, and then press F1.
Additional query words: pra grayed greyed out gray grey can't use won't work doesn't
Keywords : kbdta
Issue type : kbbug
Technology : kbAccessSearch
Last Reviewed: November 28, 2000 |