如何防止重复记录? [英] how to prevent duplicate records?

查看:98
本文介绍了如何防止重复记录?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

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

展开 | 选择 | 换行 | 行号

解决方案


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

展开 | 选择 | 换行 | 行号


很好的回答ADezii。

Ariel,

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

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

祝你好运。


主持人。


< blockquote class =post_quotes>
很好的答案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?


这篇关于如何防止重复记录?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆