The Command Or Action Is Not Available Now

Click mainmenu
Click "Show All Customers"
Use the scroll bar to go to the far right and then double click on "Dupe" option"

Then click on "Duplicate Record"  (no VBA behind this - standard function via button wizard)

Error: The Command Or Action Is Not Available Now

WHY
Key5.zip
Patrick O'DeaAsked:
Who is Participating?
 
Jeffrey CoachmanConnect With a Mentor MIS LiasonCommented:
Then this seems to be an issue with your PC or your installation of Access.

Do you have all your Updates installed for Office *And* Windows?

If you just create a brand new simple DB does it fail as well?

Can you try this on another PC?
0
 
Jeffrey CoachmanMIS LiasonCommented:
I open MainMenu and get this:
???
untitled.JPG
0
 
Patrick O'DeaAuthor Commented:
OOps !
That's my fault - It checks your username which then chooses a menu!.

Try run form frmDuplicate , then click on the duplicate button.
0
Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

 
Jeffrey CoachmanMIS LiasonCommented:
Where did you get that macro from?
I think it should be "PasteAppend", instead of "Paste"

This seems to work, but if the button is clicked a second time I get this error:


This is not the same as the error you first mentioned.

So what exactly am I supposed to be troubleshooting here?

untitled.JPG
0
 
Jeffrey CoachmanMIS LiasonCommented:
As a general note, when posting sample databases, please follow these guidelines:

Sample database notes:
1. Back up your database(s).
2. Combine the front and back ends into one database file.
3. Remove any startup options, unless they are relevant to the issue.
4. Remove any records unless they are relevant to the issue.
5. Delete any objects that do not relate directly to the issue.
6. Remove any references to any "linked" files (files outside of the database, Images, OLE Files, ...etc)
7. Remove any references to any third party Active-x Controls (unless they are relevant to the issue)
8. Remove, obfuscate, encrypt, or otherwise disguise, any sensitive data.
9. Compile the code. (From the VBA code window, click: Debug-->Compile)
10. Run the compact/Repair utility.
11. Remove any Passwords and/or security.
12. If a form is involved in the issue, set the Modal and Popup properties to: No
    (Again, unless these properties are associated with the issue)
13. Post the explicit steps to replicate the issue.
14. Test the database before posting.

In other words, ...post a database that we can easily open and immediately see and/or troubleshoot the issue.
And if applicable, also include a clear graphical representation of the *Exact* results you are expecting, based on the sample data.


JeffCoachman

0
 
Patrick O'DeaAuthor Commented:
Okay all, sorry for lack of clarity.

I have created a brand new database with one form and one table.

I have added a button to the form called "Duplicate".

In the event of clicking this button, the record displayed should be duplicated in the table.
However, an error is displayed indicating that "Paste is not available".

Bear in mind that I used the button "wizard" to achieve this functionality.  This prompted me with an option to duplicate the record.
Duplicate.accdb
0
 
Jeffrey CoachmanMIS LiasonCommented:
I don't know buddy, ...this works fine for me...

New record created with each click.
Confirmed new record added to source table.

So open up this sample you just posted and try it yourself.


On the original DB you have a "Questionalble" design...
The main table (tblDetail")does not appear to be "Normalized".
This may be part of the issue here...

What is your skill level with Database table design, normalization and relationships?
0
 
Patrick O'DeaAuthor Commented:
Thanks boaq2000,

(My design skill is actually quite good, but I understand why one of my tables looks a little erroneous).

I wonder is there something wrong with my overall database settings.

Afterall , I created a new database fronm scratch and simply added a button onto a form (via a wizard).
I will play around with it.
If anybody else is looking at this then I suggest you look at my posting 2 above!

Thanks all.
0
 
Jeffrey CoachmanMIS LiasonCommented:
Please confirm if the file you actually uploaded here is working for you?
Yes or No?

<I wonder is there something wrong with my overall database settings.>
Make sure the DB is in a "Trusted location" or no code will run.

<I will play around with it.>
ok, let us know the results...
0
 
Patrick O'DeaAuthor Commented:
I loaded the database "duplicate".

This simple database FAILS in that the "Duplicate" button on the form give a paste area.

THis is all on my own home PC and I have other more sophisticated stuff working fine.

.....
0
 
Patrick O'DeaAuthor Commented:
Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.