Solved

The Command Or Action Is Not Available Now

Posted on 2011-09-29
11
408 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

 
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
 
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

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

Question has a verified solution.

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

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

738 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