我有VBA功能IsValidEmail(
,该功能为 b。 我有一个问询:Expr1:IsValidEmail([E-mail])
。 当我提出质询时,它显示真话是1,而法勒是0。 迄今情况良好。
现在我想过滤问题,只显示无效的电子邮件。 使用“彩色设计器”的Im,因此,我仅向标准领域增加<代码>0的价值。 这使我出现“Data型Mimatch”错误。 因此,0”
(with quotes) and False. 我应如何具体确定风能的标准?
我有VBA功能IsValidEmail(
,该功能为 b。 我有一个问询:Expr1:IsValidEmail([E-mail])
。 当我提出质询时,它显示真话是1,而法勒是0。 迄今情况良好。
现在我想过滤问题,只显示无效的电子邮件。 使用“彩色设计器”的Im,因此,我仅向标准领域增加<代码>0的价值。 这使我出现“Data型Mimatch”错误。 因此,0”
(with quotes) and False. 我应如何具体确定风能的标准?
造成这一错误的原因是,我的表格中的一些记录是无纸的。 我的问询有一个条件,可以排除无端的电子邮件记录,因此,当我对IsValidEmail一栏没有任何条件时,我只要求有非null E-mail的记录。 然而,当我增加了IsValid Email的条件时,它把这一功能称作每个记录,而错误来自试图将这一错误变成一个期待扼杀的职能。
另一种方式是:
SELECT [E-Mail],
IsValidEmail([E-Mail]) <--Executed only for rows matching where clause
FROM Contacts
WHERE IsValidEmail([E-Mail]) = False; <-- Gets executed for all rows
用IsValidEmail([E-mail]
改为IsalidEmail(nz([E-mail],“X”)
解决了这一问题。
“0”一栏肯定会给你“数字”错误。 然而,无引言的那片或一片手法应当发挥作用。 我不理解为什么他们产生同样的错误。
如果你能够直接编辑文件库,就可以提出工作询问。 在本次发言中,创造新的问候、转向“Kings”和过去(将“YouTableName与你的表格名称相重)。
SELECT IsValidEmail([E-Mail]) AS valid_email
FROM YourTableName
WHERE IsValidEmail([E-Mail]) = False;
如果你这样作,你会毫不错问吗?
<>Update: 由于这一询问也产生了同样的错误,我可以建议,在没有任何标准的情况下尝试这样做。
SELECT
IsValidEmail([E-Mail]) AS valid_email,
TypeName(IsValidEmail([E-Mail])) AS type_of_valid_email
FROM YourTableName;
然而,这似乎是一个长期枪击,因为你已经告诉我们,你先前没有标准的企图没有错误。 如果这看不出问题,你是否考虑把你数据库的打印本交给我? 让我知道,你是否重新感兴趣,我谨向你提供我的电子邮件地址。
In C#, I know that I can overload the constructor for a class by specifying it in the body of the class: public class MyClass() { public MyClass(String s) { ... } } This overrides the default ...
I have an Access app where I use search functionality. I have a TextBox and a Search Button on the form, and it does a wildcard search of whatever the user enters in the TextBox, and displays the ...
I recently switched to Outlook 2007 and noticed that my VBA-macros won t work. I use the following code to open a new appointment-item (and fill it automatically). It worked perfect in Outlook 2003, ...
The following code works. the connection opens fine but recordset.recordCount always returns -1 when there is data in the table. ANd If I try to call any methods/properties on recordset it crashes ...
I m using Application run to call several macros in order like this. Sub Run_All_Macros() Application.Run ("Macro_1") Application.Run ("Macro_1") End Sub When I start Run_All_Macros, all the ...
I m using Microsoft Office 2003 and creating a bunch of template documents to standardize some tasks. I asked this on Superuser.com and got no response so I m thinking it s too program-y and hoping I ...
I have to deal with a few macros (not VBA) in an inherited Access application. In order to document them, I would like to print or list the actions in those macros, but I am very dissatisfied by ...
I need to ensure a Macro which works on Visio 2003 doesn t cause problems on lower versions of Visio: specifically because I m writing to a property which doesn t exist on lower versions of Visio. ...