DCOUNT。 [英] DCount.
问题描述
我在这里被一名成员给了我这段代码，但我仍然被卡住了...我想要
能够根据电子邮件查看表格中是否还有其他订单
地址。但我一直得到#Name？这个错误是什么意思？
Me.txtDuplicatesMessage =你已经拥有 &
DCount（From Email Address，tblDownload，From Email Address =''"&
Me.Text13244&" ;''"）& "使用此电子邮件地址的客户。
txtDuplicatesMessage =我希望上面显示的文本框
来自电子邮件地址=字段名称
Text13244 =表格上的电子邮件地址文本框绑定到发件人电子邮件地址
字段。
TIA
-
亲切的问候，
客户服务，
Blue Lagoon产品
http://www.fastminimoto.co.uk
PS为了让我们有效地回复您的电子邮件，请始终包含
原始邮件。谢谢。
Hi, I was given this code by a member on here but I am still stuck...I want
to be able to see if there is other orders in the table based on the email
address. But I keep getting #Name? what does this error mean?
Me.txtDuplicatesMessage = "You already have " &
DCount("From Email Address", "tblDownload", "From Email Address=''" &
Me.Text13244 & "''") & " customers with this email address."
txtDuplicatesMessage = Text box that I want the above to appear in
From Email Address = Field Name
Text13244 = Email address text box on form bound to From Email Address
field.
TIA
--
Kind Regards,
Customer Services,
Blue Lagoon Products
http://www.fastminimoto.co.uk
P.S. For us to answer your emails efficiently, please always include the
original message. Thank you.
推荐答案
" N J" <在** @ bluelagoonproducts.com>写在
新闻：rI ***************** @ fe2.news.blueyonder.co.uk：
"N J" <in**@bluelagoonproducts.com> wrote in
news:rI*****************@fe2.news.blueyonder.co.uk :
我在这里得到了一个成员的代码，但我仍然被卡住......我希望能够根据电子邮件查看表格中是否还有其他订单地址。但我一直得到
#Name？这个错误是什么意思？
Me.txtDuplicatesMessage =你已经拥有 &
DCount（From Email Address，tblDownload，From Email
Address =''& Me.Text13244&"''"）& "客户使用此电子邮件地址。
txtDuplicatesMessage =我希望上面显示的文本框
出现在电子邮件地址=字段名称
Text13244 =电子邮件地址表格上的文本框绑定到来自电子邮件
地址字段。
TIA
处理表名和字段时，访问是脑死亡的/>
包含空格的名称。用方括号分隔
在引号内。
DCount（[来自电子邮件地址]，tblDownload，[来自]电子邮件地址] =''"& Me.Text13244&"''"）
Hi, I was given this code by a member on here but I am still
stuck...I want to be able to see if there is other orders in
the table based on the email address. But I keep getting
#Name? what does this error mean?
Me.txtDuplicatesMessage = "You already have " &
DCount("From Email Address", "tblDownload", "From Email
Address=''" & Me.Text13244 & "''") & " customers with this email
address."
txtDuplicatesMessage = Text box that I want the above to
appear in From Email Address = Field Name
Text13244 = Email address text box on form bound to From Email
Address field.
TIA
Access is brain-dead when dealing with table names and field
names containing spaces. Delimit them with square brackets
inside the quotes.
DCount("[From Email Address]", "tblDownload", "[From Email Address] =''" & Me.Text13244 & "''")
-
Bob Quintal
PA是我改变了我的电子邮件地址。
--
Bob Quintal
PA is y I''ve altered my email address.
" Bob Quintal" < RQ ****** @ sPAmpatico.ca>在消息中写道
news：1126378323.06183762127525c90dcb55210455ad6f@t eranews ...
"Bob Quintal" <rq******@sPAmpatico.ca> wrote in message
news:1126378323.06183762127525c90dcb55210455ad6f@t eranews...
" N J" <在** @ bluelagoonproducts.com>在
新闻中写道：rI ***************** @ fe2.news.blueyonder.co.uk：
"N J" <in**@bluelagoonproducts.com> wrote in
news:rI*****************@fe2.news.blueyonder.co.uk :
你好，我在这里得到了一个会员的代码，但我仍然被卡住......我希望能够根据电子邮件地址查看表格中是否有其他订单。但我一直得到
#Name？这个错误是什么意思？
Me.txtDuplicatesMessage =你已经拥有 &
DCount（From Email Address，tblDownload，From Email
Address =''& Me.Text13244&"''"）& "客户使用此电子邮件地址。
txtDuplicatesMessage =我希望上面显示的文本框
出现在电子邮件地址=字段名称
Text13244 =电子邮件地址表格上的文本框绑定到来自电子邮件
地址字段。
TIA
Hi, I was given this code by a member on here but I am still
stuck...I want to be able to see if there is other orders in
the table based on the email address. But I keep getting
#Name? what does this error mean?
Me.txtDuplicatesMessage = "You already have " &
DCount("From Email Address", "tblDownload", "From Email
Address=''" & Me.Text13244 & "''") & " customers with this email
address."
txtDuplicatesMessage = Text box that I want the above to
appear in From Email Address = Field Name
Text13244 = Email address text box on form bound to From Email
Address field.
TIA
处理表名和字段时，访问是脑死亡的/>包含空格的名称。在引号内用方括号分隔它们。
DCount（[From Email Address]，tblDownload，[From Email
Access is brain-dead when dealing with table names and field
names containing spaces. Delimit them with square brackets
inside the quotes.
DCount("[From Email Address]", "tblDownload", "[From Email
地址] =''"& Me.Text13244&"''"）
Address] =''" & Me.Text13244 & "''")
-
Bob Quintal
PA是我已经改变了我的电子邮件地址。
--
Bob Quintal
PA is y I''ve altered my email address.
哎呀..
仍然无法正常工作： （
DCount（" [From Email Address]"，" tblDownload"，" [From Email Address] =''"&
Me.Text13244&"''"）
只需继续获取#Name？
Oops..
Still doesn''t work :(
DCount("[From Email Address]", "tblDownload", "[From Email Address] =''" &
Me.Text13244 & "''")
Just keep getting #Name?
" N J"< in ** @ bluelagoonproducts.com>写在
news：t％****************** @ fe2.news.blueyonder .co.uk：
"N J" <in**@bluelagoonproducts.com> wrote in
news:t%******************@fe2.news.blueyonder.co.u k:
" Bob Quintal" rq ****** @ sPAmpatico.ca>写在消息中
新闻：1126378323.06183762127525c90dcb55210455ad6f@t era新闻......
"Bob Quintal" <rq******@sPAmpatico.ca> wrote in message
news:1126378323.06183762127525c90dcb55210455ad6f@t eranews...
&n; N J" <在** @ bluelagoonproducts.com>在
新闻中写道：rI ***************** @ fe2.news.blueyonder.co.uk：
"N J" <in**@bluelagoonproducts.com> wrote in
news:rI*****************@fe2.news.blueyonder.co.uk :
你好，我在这里得到了一个会员的代码，但我仍然被卡住......我希望能够根据电子邮件地址查看表格中是否有其他订单。但我一直得到
#Name？这个错误是什么意思？
Me.txtDuplicatesMessage =你已经拥有 &
DCount（From Email Address，tblDownload，From Email
Address =''& Me.Text13244&"''"）& "有这个
电子邮件地址的客户。
txtDuplicatesMessage =我想要上面的文本框
出现在电子邮件地址=字段名称
Text13244 =电子邮件地址表格上的文本框绑定到来自
电子邮件地址字段。
TIA
Hi, I was given this code by a member on here but I am still
stuck...I want to be able to see if there is other orders in
the table based on the email address. But I keep getting
#Name? what does this error mean?
Me.txtDuplicatesMessage = "You already have " &
DCount("From Email Address", "tblDownload", "From Email
Address=''" & Me.Text13244 & "''") & " customers with this
email address."
txtDuplicatesMessage = Text box that I want the above to
appear in From Email Address = Field Name
Text13244 = Email address text box on form bound to From
Email Address field.
TIA
处理表名和字段时访问权限已经死亡/>包含空格的名称。在引号内用方括号分隔它们。
DCount（[From Email Address]，tblDownload，[From Email
Access is brain-dead when dealing with table names and field
names containing spaces. Delimit them with square brackets
inside the quotes.
DCount("[From Email Address]", "tblDownload", "[From Email
地址] =''"& Me.Text13244&"''"）
Address] =''" & Me.Text13244 & "''")
-
Bob Quintal
PA是我已经改变了我的电子邮件地址。
--
Bob Quintal
PA is y I''ve altered my email address.
哎呀..
仍然无法工作:(
DCount（[From Email Address]，tblDownload，[From Email
Address] =''"& Me.Text13244&"''"）
只是不断获取#Name？
Oops..
Still doesn''t work :(
DCount("[From Email Address]", "tblDownload", "[From Email
Address] =''" & Me.Text13244 & "''")
Just keep getting #Name?
其中是代码所在的位置，格式为''代码模块或
全局模块或文本框的控制源？
-
Bob Quintal
PA是你我是修改了我的电子邮件地址。
where is the code located, in the form''s code module or in a
global module or in the textbox''s control source?
--
Bob Quintal
PA is y I''ve altered my email address.
这篇关于DCOUNT。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
