A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

"The command or action 'Delete Record' isn't available now" messag



 
 
Thread Tools Display Modes
  #1  
Old June 24th, 2005, 05:25 PM
mscertified
external usenet poster
 
Posts: n/a
Default "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  
Old June 25th, 2005, 03:49 AM
Allen Browne
external usenet poster
 
Posts: n/a
Default

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 09:31 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.