将记录复制为新记录 [英] copy record as a new record

问题描述

我正在尝试编写一个代码来将当前记录复制为新记录（基本上，我想复制当前记录）。但是当我点击命令按钮时，它什么也没做。这是我的代码：

Hi,
I am trying to write a code to copy the current record as a new record (basicly, I would like to duplicate the current record). but then when I click on the command button, it didn''t do anything. Here is my code:

展开 | 选择 | Wrap | 行号

推荐答案

以下代码工作正常，并会自动添加新的，按预期复制记录。如果您有主键或唯一索引（如社会安全号码），您将遇到麻烦。代码将添加新记录，但您将永远无法保存它。希望这会有所帮助。

The following code works fine, and will automatically Add a New, Duplicate Record as intended. Where you will run into trouble is if you have a Primary Key or Unique Index such as a Social Security Number. The code will Add the New Record, but you will never be able to Save it. Hope this helps.

展开 | 选择 < span class =codeDivider> | Wrap | 行号

谢谢，

这是我使用的代码。这是来自wizzard。但当我点击它时，它给了我一条错误消息The command / actionpaste append现在不可用。我不知道为什么它只是在我的数据库的这个特定形式上给了我那种消息。顺便说一句，我没有任何唯一的密钥，主键只是一个自动编号。


谢谢！

thanks,
that''s the code I used. It''s from the wizzard. but when I click on it, it gave me an error message "The command/action "paste append" is not available now". I have no clue why it gave me that kind of message just on this particular form of my database. By the way, I don''t have any unique key, the primary key is just an auto number.

thanks!

你可以试试这个：

Hi,

you could try this:

展开 | 选择 | Wrap | 行号

这篇关于将记录复制为新记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！