且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何防止重复记录?

更新时间:2023-01-29 21:01:48


i创建了一个函数,用于将四个文本框中的数据输入到表中。如何防止同一个mth / Yr的重复记录进入表中?允许在参考mt / Yr的情况下编辑表格中的数据,但如何防止重复记录?

展开 | 选择 | 换行 | 行号


很好的回答ADezii。

Ariel,

如果您认为此决议的任何部分太复杂而无法实施 - 别担心,只是回复解释哪些部分你发现很复杂,ADezii(或者其他人即使他太忙)也能帮助你完成它。

错误处理是VBA的一个非常重要的部分代码但是有些人避免使用它。不要让你吓跑这个解决方案。

祝你好运。


主持人。



很好的答案ADezii。

Ariel,

如果您认为此决议的任何部分太复杂而无法实施 - 别担心,只需回复解释哪些部件你发现很复杂,ADezii(或其他人,即使他太忙)也能帮你解决这个问题。

错误处理是VBA代码的一个非常重要的部分,但有些人避免使用它。不要让你吓跑这个解决方案。

祝你好运。


主持人。



谢谢。我是编程新手......我不明白一件事。任何类似的示例程序,我可以从中获取想法?


i have created a function to input data from four textboxes into a table. how do i prevent duplicate records of the same mth/Yr into the table? editing of the data in the table with reference to the mt/Yr is allowed, but how to prevent duplicate records?

Expand|Select|Wrap|Line Numbers

i have created a function to input data from four textboxes into a table. how do i prevent duplicate records of the same mth/Yr into the table? editing of the data in the table with reference to the mt/Yr is allowed, but how to prevent duplicate records?

Expand|Select|Wrap|Line Numbers


Nice answer ADezii.
Ariel,
If you feel that any part of this resolution is too complicated for you to implement - don''t worry, just post back explaining which parts you find complicated and ADezii (or someone else even if he''s too busy) will be able to help you through it.
Error handling is a very important part of VBA code but some people avoid using it. Don''t let that frighten you off this solution.
Best of luck.

MODERATOR.


Nice answer ADezii.
Ariel,
If you feel that any part of this resolution is too complicated for you to implement - don''t worry, just post back explaining which parts you find complicated and ADezii (or someone else even if he''s too busy) will be able to help you through it.
Error handling is a very important part of VBA code but some people avoid using it. Don''t let that frighten you off this solution.
Best of luck.

MODERATOR.

thank you. i am new to programming...i don''t understand a single thing. any similiar sample programs where i can get ideas from?


登录 关闭
扫码关注1秒登录
如何防止重复记录?
发送“验证码”获取 | 15天全站免登陆
上一篇 : :仅使用一个查询删除重复记录下一篇 : mysql数据透视表的麻烦

相关阅读

技术问答最新文章