By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,475 Members | 2,093 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,475 IT Pros & Developers. It's quick & easy.

PasteAppend - Clipboard not responding

bwesenberg
P: 17
I have created an Access Front End Database that many people in one of the departments use. Each user has their own copy of the Front End on their Computer. The Back End is on a SQL Server.

On one of the forms I created a Duplicate Record Button using the Wizard in Access. I have ONE user who has trouble using this button.

She uses it to copy records over and over and over. Then she changes just a few pieces of data as needed.

She often gets one of two error messages:
The Clipboard isn't responding, so Commercial Workflow(name of DB) can't paste the Clipboard's contents.

or

The command or action 'PasteAppend' isn't available now.

I have tried to recreate these errors on my computer with my front end. My Front End is the master they copy from. But I can not recreate the error.

I did check a few things on her front-end and my front end and found 1 setting different
On the Clipboard there is an options button and the first setting “Show Office Clipboard Automatically" on my front end is not checked and hers was checked. I changed that and the next day she was still having problems.

I have done a lot of searching on this and I just keep coming up at a dead end. Can anyone out there help me?
Oct 11 '07 #1
Share this Question
Share on Google+
6 Replies


nico5038
Expert 2.5K+
P: 3,072
Hmm, can you post the code in the OnClick event of the copy button ?
I assume it works with the Docmd.MenuItem.
Better to switch to using the "Docmd.Runcommand" command as that's not depending on the available menu items.

Nic;o)
Oct 11 '07 #2

missinglinq
Expert 2.5K+
P: 3,532
I wasn't even aware that the DoRun.MenuItem used the Clpboard for this! As Nico said, this is really a poor way to accomplish this job. Better to use


Expand|Select|Wrap|Line Numbers
  1. DoCmd.RunCommand acCmdSelectRecord
  2. DoCmd.RunCommand acCmdCopy
  3. DoCmd.RunCommand acCmdPasteAppend  
I've seen reports of this type of problem before, from time to time, and the general consensus is that the problem lies with available memory/memory not being released after the Copy & Paste is done. Significantly, every single report I've seen mentions that when this happens, the Clipboard exhibits the same behavior in other Office apps. Also usually reported is that rebooting eliminates the problem at least temporarily, which would seem to support a memory problem being the root cause.

I'm not sure if the above code will alleviate the problem, since I don't know exactly what mechanism Access uses to carry out the actions.

What I personally do to address the problem is use code like this, that copies the desired fields to variables, goes to a new record, then plugs the variables back into the correct fields.


Expand|Select|Wrap|Line Numbers
  1. 'Copy fields from original record to variables
  2.  
  3.   NewField1 = Me.YourField1
  4.  
  5.   NewField2 = Me.YourField2
  6.  
  7.     NewField3 = Me.YourField3   'Go to a new record
  8.  
  9.   DoCmd.GoToRecord , , acNewRec
  10.  
  11. 'Plug in old values into new record
  12. Me.YourField1.Value = NewField1
  13.  
  14.   Me.YourField2.Value = NewField2
  15.  
  16.   Me.YourField3.Value = NewField3
  17.  
  18.  
Linq ;0)>
Oct 11 '07 #3

bwesenberg
P: 17
Sorry it took so long to get back to this. I have been so busy.
Here is my code for the duplicat record button.

Private Sub Command60_Click()

On Error GoTo Err_Command60_Click


DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 2, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 5, , acMenuVer70 'Paste Append

Exit_Command60_Click:
RaterID.SetFocus
Exit Sub

Err_Command60_Click:
MsgBox Err.Description
Resume Exit_Command60_Click


End Sub
Oct 30 '07 #4

bwesenberg
P: 17
I have changed the code to use:

DoCmd.RunCommand acCmdSelectRecord
DoCmd.RunCommand acCmdCopy
DoCmd.RunCommand acCmdPasteAppend

I am having the user test it for a few days and let me know.

Thanks for the thought you both put into this. If this does not work I will try the other code.
Oct 30 '07 #5

bwesenberg
P: 17
The user contacted me already and it did not work.
I will try the other option.
Oct 30 '07 #6

bwesenberg
P: 17
So far so good. I talked with the user today and she said that she has not had a problem.
Thanks so much for your help.
Oct 31 '07 #7

Post your reply

Sign in to post your reply or Sign up for a free account.