溢出错误和运行时错误'3075'： [英] Over Flow Error and Run-time Error '3075':
问题描述
我遇到Access 2010的问题，该界面包括以下输入选项：姓氏，名字，SSN和出生日期。
自2012年以来Access一直运行良好，从2015年1月21日起我们突然遇到问题，以下是以下错误：
1.溢出
2.运行时错误'''305''：
查询表达式''LastNameLike''中的语法错误* Akers *''AND FirstName喜欢''* Mike *''和SSN喜欢''* 100101001 *''; DOB喜欢＃4/24/1982＃''。
我使用了调试工具，它带我去了.Referral.Form.Filter = filterstr
以下是调试器突出显示的代码部分：
I''m having issues with Access 2010, the interface includes the following input options:Last Name, First Name, SSN, and Birth date.
Access was working great since 2012 and all of a sudden we are getting issues since the 21 of January 2015, here are the following errors:
1. Overflow
2. Run-time Error''3075'':
Syntax error in query expression ''LastNameLike''*Akers*'' AND FirstName Like''*Mike*''AND SSN Like''*100101001*''; DOB Like#4/24/1982#''.
I used the debug tool and it takes me to Me.Referral.Form.Filter = filterstr
Here is the section of the Code that the debugger highlighted:
推荐答案
调试器以粗体突出显示以下内容：
Debugger is highlighting the following in bold:
您的问题位于上一段中的第25行，其中已使用分号代替AND：
filterstr = filterlast &安培; " AND和&安培; filterfirst& " AND和&安培;过滤器& " ;;" & filterbob
替换为
filterstr = filterlast& " AND和&安培; filterfirst& " AND和&安培;过滤器& " AND" & filterbob
语法错误信息绝对准确 - 您将在原始帖子中的DOB之前看到分号。由于过滤器字符串出错，当你修复列出的原因时，你得到的所有其他错误都会消失。
-Stewart
Your problem is at line 25 in the segment above, where a semicolon has been put in place of an AND:
filterstr = filterlast & " AND " & filterfirst & " AND " & filterssn & ";" & filterdob
Replace with
filterstr = filterlast & " AND " & filterfirst & " AND " & filterssn & " AND " & filterdob
The syntax error message is absolutely accurate - you will see the semicolon just before the DOB in your original post. As the filter string is in error all the other errors you are getting should disappear when you fix the cause listed.
-Stewart
我做了你问什么，现在我得到运行时错误语法错误（缺少运算符）
I did what you ask and now I get Run-time error Syntax error (missing operator)
这篇关于溢出错误和运行时错误'3075'：的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
