快速平台通用查询窗体在筛选不为空时出现:3075语法错误 在查询表达式'([字段] Not (Is Null or [字段]=''))'中。
手动更改一下通用查询窗体【SysFrmGeneralQuickQuery】的btnQuery的单击事件代码来修正:
原代码:
Case "Does Not Equal Blank"
strWhere = Me.cboField & " Not (Is Null or " & Me.cboField & "='')"
修改成:
Case "Does Not Equal Blank"
strWhere = Me.cboField & " Is Not Null or " & Me.cboField & "<>''"
或者修改成:
Case "Does Not Equal Blank"
strWhere = "Not ( " & Me.cboField & " Is Null or " & Me.cboField & "='')"