如何检查键入的客户名称是否与表中的名称匹配 [英] how to check a typed customer name whether it matches a name from a table
问题描述
大家好!
表单中有一个文本框,当我输入客户名称时,我希望
键入的名称为检查名称是否与customer_info表的
customer_name字段中的名称匹配。可能吗?我不想要
来使用组合框。有什么建议?感谢您的帮助!
Paul来自斯洛伐克布拉迪斯拉发
Hi, everybody!
There is a text box in the form, when I type a customer name, I would like
the typed name to be checked whether the name matches one in the
customer_name field of the customer_info table. Is it possible? I don''t want
to use the combo box. Any suggestions? Thank you for any help!
Paul from Bratislava, Slovakia
推荐答案
Paul T .Rong写道:
Paul T. Rong wrote:
大家好!
表格中有一个文本框,当我输入客户名称时,我想
要检查的类型名称是否与customer_info表的
customer_name字段中的名称匹配。可能吗?我不想要
使用组合框。有什么建议?感谢您的帮助!
来自斯洛伐克布拉迪斯拉发的Paul
Hi, everybody!
There is a text box in the form, when I type a customer name, I would like
the typed name to be checked whether the name matches one in the
customer_name field of the customer_info table. Is it possible? I don''t want
to use the combo box. Any suggestions? Thank you for any help!
Paul from Bratislava, Slovakia
添加到BeforeUpdate活动
if isnull(dlookup(" [customer_name]"," customer_info"," [customer_name] ="&
me!txtBox)then
''客户名称不存在
其他
''客户名称存在
''取消更新到该领域
取消= true
endif
Add to the BeforeUpdate event
if isnull(dlookup("[customer_name]","customer_info","[customer_name]=" &
me!txtBox) then
''The customer name does not exist
else
''The customer name exists
''cancel the update to the field
cancel=true
endif
" Paul T. Rong"< et***@hotmail.com>在留言新闻中写道:< M3 ********************* @ news.chello.at> ...
"Paul T. Rong" <et***@hotmail.com> wrote in message news:<M3*********************@news.chello.at>...
大家好!
表单中有一个文本框,当我输入客户名称时,我想要检查输入的名称是否有名称匹配customer_info表的
customer_name字段中的一个。是否可能?我不想使用组合框。有什么建议吗?谢谢你任何帮助!
Paul来自斯洛伐克布拉迪斯拉发
Hi, everybody!
There is a text box in the form, when I type a customer name, I would like
the typed name to be checked whether the name matches one in the
customer_name field of the customer_info table. Is it possible? I don''t want
to use the combo box. Any suggestions? Thank you for any help!
Paul from Bratislava, Slovakia
是的,使用正确的控件太简单了。否则试试DCount。
Yeah, using the right control would be too easy. Otherwise try DCount.
谢谢,gj,它的工作原理,非常感谢。
Paul
gj <去**** @ google.google> ??????:ry ******************* @ news02.tsnz.net ...
Thanks, gj, it works, thank you very much.
Paul
"gj" <go****@google.google> ??????:ry*******************@news02.tsnz.net...
Paul T. Rong写道:
Paul T. Rong wrote:
大家好!
表格中有一个文本框,当我输入客户名称时,我会像输入的名字一样
要检查名称是否与customer_info表的
customer_name字段中的名称匹配。可能吗?我不想b $ b想要使用组合框。有什么建议?感谢您的帮助!
来自斯洛伐克布拉迪斯拉发的Paul
Hi, everybody!
There is a text box in the form, when I type a customer name, I would like the typed name to be checked whether the name matches one in the
customer_name field of the customer_info table. Is it possible? I don''t want to use the combo box. Any suggestions? Thank you for any help!
Paul from Bratislava, Slovakia
添加到BeforeUpdate活动
如果是空的(dlookup(" [customer_name]"," customer_info"," [customer_name] ="&
me!txtBox)然后
''客户名称不存在>其他
''客户名称存在
''取消对该字段的更新
cancel = true
endif
Add to the BeforeUpdate event
if isnull(dlookup("[customer_name]","customer_info","[customer_name]=" &
me!txtBox) then
''The customer name does not exist
else
''The customer name exists
''cancel the update to the field
cancel=true
endif
这篇关于如何检查键入的客户名称是否与表中的名称匹配的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!