清除剪贴板用于修复PasteAppend错误 [英] Clear clipboard use to fix PasteAppend error
问题描述
我使用以下例程复制行并将其附加到表中。然后用户更改与当前日期相关的适当信息。
使用CopyPA宏发布时，我一直收到错误。错误：操作失败条件：True操作名称：RunCommand参数：38。
当我暂停时，消息命令或操作'PasteAppend''现在不可用 ;。有时它会起作用，但其他时候，我得到了错误。根据我在搜索此错误时发现的内容，当时剪贴板已满，无法接受更多内容。我试图添加一个例程来清除剪贴板，这似乎并没有起作用。也许我没有正确定义它。有人可以看看这个并告诉我是否在正确的位置正确定义了函数/ sub？你能告诉我为什么我得到错误，如果我走在正确的轨道上？我正在使用Access 2003.
CopyPA宏：
I am using the following routine to copy a row and append it to the table. The user then changes appropriate information relevant to the current date.
I keep getting an error when using CopyPA macro as posted. The error: Action failed Condition: True Action Name: RunCommand Arguments: 38.
When I halt it, the message "the command or action ''PasteAppend'' is not available now". Sometimes it will work, but then other times, I get the error. From what I found while searching for this error, the clipboard is full at the time and cannot accept anything more. I attempted to add a routine to clear the clipboard, and that doesn''t seem to be working. Perhaps I don''t have it defined correctly. Could someone look at this and tell me if I have the functions/sub correctly defined in the right location? Can you tell me why I am getting the error and if I am on the right track? I am using Access 2003.
CopyPA macro:
推荐答案
宏看起来对我不对。无论如何我都不会使用宏，但我怀疑你在那里有什么真正的意义。同一行上的多个命令肯定是不对的。
代码在很多地方看起来都不对，但你应该能够自己看到它，如果你遵循发布前（VBA或SQL）代码中的说明。如果您遇到的错误不是由容易避免的错误引起的（链接应该有帮助），那么请按照指示正确发布详细信息，我们将看到我们能为您做些什么。
The macro looks wrong to me. I don''t work with macros ever anyway, but I somehow doubt what you have there makes any real sense. Multiple commands on the same line surely can''t be right.
The code looks wrong in a number of places, but you should be able to see that for yourself if you follow the instructions in Before Posting (VBA or SQL) Code. If/when you have a situation with an error that isn''t caused by easily avoidable errors (The link should help with that), then please post the details correctly as indicated and we''ll see what we can do for you.
抱歉，在邮件中粘贴时存在一些格式问题。我调整了它。我还会看一下提供的链接。谢谢。
Sorry, there were some formatting problems from pasting in the message. I have adjusted it. I will also look at the link provided. Thanks.
干得好:-)
你的代码第25行仍然是不可能的代码。链接的文章应该有所帮助，但如果你的代码有效时仍然卡住，那么重新发布它，我们可以为你调查。
Good job :-)
Line #25 of your code is still suffering from being impossible code though. The linked article should help with that, but if you''re still stuck when your code is valid then repost it and we can look into it for you.
这篇关于清除剪贴板用于修复PasteAppend错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
