Command or Action not available

Joined
Jul 22, 2005
Messages
9
Reaction score
0
Hi Everyone,

I am using command buttons in my form in MS ACCESS 2000 to perform save and to duplicate values. However, when I open/run my form and start filling the data and press 'duplicate command' button, I got these errors.

Yesterday it said
'The Command or action 'Copy' not available'

and today it is showing me this error :
'The Command or action 'paste' not available'.

However, yesterday 'paste' worked fine. I am not sure what is going on with mu Access. Can someone please let me know what is happening....

The code for duplicate command button is shown below.
----------------------------------------------------------------
------------------------------------------------------------
Private Sub Duplicates_insert_Click()
On Error GoTo Err_Duplicates_insert_Click

DoCmd.RunCommand acCmdSelectRecord
DoCmd.RunCommand acCmdCopy
DoCmd.RunCommand acCmdRecordsGoToNew
DoCmd.RunCommand acCmdSelectRecord
DoCmd.RunCommand acCmdPaste

If Me.Dirty Then
DoCmd.RunCommand acCmdUndo
Else
End If

Exit_Duplicates_insert_Click:
Exit Sub

Err_Duplicates_insert_Click:
MsgBox Err.Description
Resume Exit_Duplicates_insert_Click
End Sub
---------------------------------------------------------------

Thanks
 
Last edited:

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top