If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"The command or action 'Delete Record' isn't available now" messag
"The command or action 'Delete Record' isn't available now" message
What does this mean? I'm trying to delete the record on a form. Why would delete not be available? |
#2
|
|||
|
|||
There could be lots of reasons why a deletion cannot compete, e.g.:
- The record is dirty and cannot be saved. Try undoing the form, and then deleting. - The code is being executed in a inappropriate event (such as the KeyDown of a text box that has a BeforeUpdate event that can't complete, and so the changes to the record cannot be handled, and so the record cannot be deleted.) - The form is a Popup, and uses DoMenuItem to attempt the delete. Try: RunCommand acCmdDeleteRecord - The form's AllowDeletions property is No. - The form or its recordsource or the data file or network share or drive (CD) is read-only. - The form is at a new record, or there are no records in the form, so there is nothing to delete. - The user does not have delete permissions (Access security). -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "mscertified" wrote in message ... "The command or action 'Delete Record' isn't available now" message What does this mean? I'm trying to delete the record on a form. Why would delete not be available? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I delete a record with an "invalid arguement" error? | PStorm7 | General Discussion | 1 | April 6th, 2005 05:46 PM |
Inspect record, replace null field on output | RNUSZ@OKDPS | Setting Up & Running Reports | 3 | April 5th, 2005 04:27 PM |
Delete Record Confirmation | Tiago | Using Forms | 1 | March 31st, 2005 12:11 PM |
Yet another beginner that cannot delete record in a half filled fo | Richard Smith | Using Forms | 1 | March 16th, 2005 02:25 PM |
Deleting Records does not Delete Records | Lucky Man Cree | New Users | 7 | July 6th, 2004 11:33 PM |