Solved

The Command Or Action Is Not Available Now

Posted on 2011-09-29
11
375 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
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
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

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Suggested Solutions

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

760 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

19 Experts available now in Live!

Get 1:1 Help Now