重复条目警告消息 [英] Duplicate Entry Warning Message

问题描述

我正在尝试在标记为before_update警告消息的文本框中获取重复条目。该字段是Hospital_Number字段。在表格Voc Rehab DB中。医院号码是一个文本字段，因为医院号码可以包括以下内容：U / G39401


目前我有以下代码：

I''m trying to get a duplicate entry into a textbox flagged as a before_update warning message. The field is "Hospital_Number" within the table "Voc Rehab DB". The Hospital Number is a text field since hospital numbers can include things like: U/G39401

At the moment I have the following code:

展开 | 选择 | Wrap | 行号

推荐答案

您需要告诉我们发生了什么。在我的头脑中，您的代码没有任何问题。您是收到错误消息还是未执行您想要执行的操作？

You need to tell us what is happening. Off the top of my head, nothing looks wrong with your code. Are you getting an error message or is it not doing what you want to happen?

对不起，是的，代码会导致它在文本框中输入错误消息。即使该特定医院号码没有现有副本。

Sorry, yes, the code causes it to come up with an error message whatever is entered into the textbox. Even if there isn''t an existing duplicate for that particular hospital number.

确切的错误消息和号码是什么？此外，如果单击错误上的调试按钮，哪条线会突出显示？

What is the exact error message and number? Also, what line gets highlighted if you click the Debug button on the error?

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