View Full Version : Access 2003 Copy Paste problem


jimgriggs
03-27-2007, 07:35 AM
I have several Access 2003 databases that the Copy Paste functions become disabled (grayed out) on a random basis. If I reboot, copy paste are active until they are used once or twice and then they become disabled. This happened on a client´s windows xp system and my windows 2000 system. Not sure, but it may be related to the amount of data in the copy buffer.
Has there been a recent access update that causes it to not clear the copy buffer? If so, how can I clear it without having to reboot?

Help ...

DJkarl
03-27-2007, 08:51 AM
I have several Access 2003 databases that the Copy Paste functions become disabled (grayed out) on a random basis. If I reboot, copy paste are active until they are used once or twice and then they become disabled. This happened on a client´s windows xp system and my windows 2000 system. Not sure, but it may be related to the amount of data in the copy buffer.
Has there been a recent access update that causes it to not clear the copy buffer? If so, how can I clear it without having to reboot?

Help ...

You could try this API call

Declare Function EmptyClipboard Lib "user32.dll" () As Long

put this into a VBA module then create a button that calls it, this should clear out the clipboard memory.

jimgriggs
03-27-2007, 09:01 AM
Thanks .. i will give it a try. Any idea what is causing the problem?

boblarson
03-27-2007, 09:06 AM
are the users just using the normal copy and paste method (either with mouse or Ctrl+C / Ctrl+V)? Or, is there some code doing it for them? Also, what type of data are they copying and pasting, and why? Depending on what they are doing, it could be something completely outside of Access that is causing the problem. I currently seem to have a problem at times with my clipboard (Access 2000) when I've done a few things with SnagIt, or have some other program open which seems to lock the clipboard.