检查重复的ID [英] Checking For Duplicate IDs

问题描述

我刚刚创建了一个数据库，需要设置一个规则，以便当有人在表单中输入某个ID时，它会根据已经存在于数据库中的ID来检查它，并返回错误消息（如果它已经存在）。


我害怕我有点新手，所以如果有人可以提供帮助，我将非常感激。


谢谢

I have just created a database and need to set up a rule so that when someone enters a certain ID into the form it checks it against the ID''s already in the database and returns a error message if it already exists.

Im afraid im a bit of a novice so if anyone can help it would be very appreciated.

Thanks

推荐答案

我刚刚创建了一个数据库，需要设置一个规则，以便当有人在表单中输入某个ID时，它会检查它反对已经存在于数据库中的ID并返回错误消息（如果它已经存在）。


我害怕我有点新手所以如果有人可以帮助它将非常感激。


谢谢

I have just created a database and need to set up a rule so that when someone enters a certain ID into the form it checks it against the ID''s already in the database and returns a error message if it already exists.

Im afraid im a bit of a novice so if anyone can help it would be very appreciated.

Thanks

只需在设计视图中打开表格即可。转到ID字段并将Indexed属性设置为Yes（No Duplicates）。这将阻止两次输入相同的ID。


Mary

Just open the table in design view. Go to the ID field and set Indexed property to Yes (No Duplicates). This will prevent the same ID being entered twice.

Mary

已设置Indexed属性为Yes（No Duplicates）但是当您输入时将数据转换为表单，它允许您输入所有数据，并且只有在您尝试保存记录时才会知道存在重复的ID。是否有即时方式让用户知道他们何时输入了重复的ID？


Tom

The Indexed property to Yes (No Duplicates) is already set but when you enter data into a form it allows you to enter all the data and only lets you know there is a duplicate ID when you try to save the record. Is there an instant way of letting a user know when they have entered a duplicate ID?

Tom

Indexed属性为Yes（No Duplicates）已设置，但是当您在表单中输入数据时，它允许您输入所有数据，并且只有在您尝试保存记录时才会知道存在重复的ID。是否有即时方式让用户知道他们何时输入了重复的ID？


Tom

The Indexed property to Yes (No Duplicates) is already set but when you enter data into a form it allows you to enter all the data and only lets you know there is a duplicate ID when you try to save the record. Is there an instant way of letting a user know when they have entered a duplicate ID?

Tom

更新ID文本框的事件，我正在调用txtID ...

In the After Update event of the ID textbox which I''m calling txtID ...

展开 | 选择 | Wrap | 行号

这篇关于检查重复的ID的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！