Solved

The Command Or Action Is Not Available Now

Posted on 2011-09-29
11
384 Views
Last Modified: 2012-05-12
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
0
Comment
Question by:Patrick O'Dea
  • 6
  • 5
11 Comments
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 36816173
I open MainMenu and get this:
???
untitled.JPG
0
 

Author Comment

by:Patrick O'Dea
ID: 36816299
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
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 36816374
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
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 36816386
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
 

Author Comment

by:Patrick O'Dea
ID: 36816687
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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 36816768
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
 

Author Comment

by:Patrick O'Dea
ID: 36817848
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
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 36817961
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
 

Author Comment

by:Patrick O'Dea
ID: 36817996
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
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 500 total points
ID: 36830377
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
 

Author Closing Comment

by:Patrick O'Dea
ID: 36902021
Thanks!
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now