查找重复记录并将其值传递到更新框 [英] Find duplicate record and pass its values to the boxes for update

问题描述

大家好。

我正试图从数据中捕获重复值。在图片中我想添加新记录，然后如果记录已经存在然后转到该记录并填写所有框，然后我将按更新按钮，但如果没有，则添加新值。字段已编入索引。

Capture.JPG！[Capture.JPG]

那么如何编码呢？我非常需要它。

这里是代码：

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

解决方案

< blockquote> Recordset.AddNew

分配值

然后

Recordset.Update

但现在它说，这是因为关联对象而避免的，那是什么？

你可能需要数据。在Recordset之前


另外，我为建议答案道歉......我在这里发布新内容。我给了你一个不同的答案，但后来意识到你从Visual Basic请求不能访问，并且无法弄清楚如何删除我的帖子，所以我尽力给你一个可能有用的答案。也许其他人会更好地参与其中。


谢谢

Hello every one.
i am trying to catch duplicate values from a data. in the picture when i want to add new record, then if the record already exists then go to that record and fill all the boxes, then i will press the update button,but if not, then add new value. field is indexed.
Capture.JPG![Capture.JPG]
so how to code that? i need it very much.
here is the code:

Expand|Select|Wrap|Line Numbers

解决方案

Recordset.AddNew
assign values
then
Recordset.Update

but now it says, this is avoided because of associated object, what is that?

you probably need Data. before Recordset

Also, I apologize for suggesting an answer ... am new to posting here. I gave you a different answer but then realized you were asking from Visual Basic not Access and couldn''t figure out how to delete my post so I did my best at giving you an answer that might work. Perhaps someone else will jump in with something better.

thanks

这篇关于查找重复记录并将其值传递到更新框的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！