-- 作者:hbkongxin
-- 发布时间:2021/3/10 10:05:00
-- [求助]筛选查询窗口设计成包含
Dim Filter As
String With
e.Form.Controls("cmbProduct") If .Value IsNot
Nothing
Then Filter =
"产品 =
\'" &
.Value & "\'" End
If End
With With
e.Form.Controls("cmbCustomer") If .Value IsNot
Nothing
Then
If Filter > ""
Then Filter =
Filter & " And "
End
If Filter = Filter
& "客户 = \'" & .Value
& "\'" End
If End
With With
e.Form.Controls("cmbEmployee") If .Value IsNot
Nothing
Then
If Filter >""
Then Filter =
Filter & " And "
End
If Filter = Filter
& "雇员 = \'" & .Value
& "\'" End
If End
With With
e.Form.Controls("StartDate") If .Value IsNot
Nothing
Then
If Filter >""
Then Filter =
Filter & " And "
End
If Filter = Filter
& "日期 >= #" & .Value
& "#" End
If End
With With
e.Form.Controls("EndDate")
If .Value IsNot
Nothing
Then
If Filter >""
Then Filter =
Filter & " And "
End
If Filter = Filter
& "日期 <= #" & .Value
& "#" End
If End
With If
e.Form.Controls("rdoYifu").Checked =
True
\'
如果付款状态选择了"已付" If Filter >""
Then Filter = Filter
& " And " End
If Filter = Filter &
"已付款 = True" End
If If e.Form.Controls("rdoWeifu").Checked = True \'
如果付款状态选择了"未付" If Filter >"" Then
Filter = Filter
&
"
And " End If
Filter = Filter
&
"已付款 = False Or
已付款 Is Null" End If If
Filter > ""
Then Tables("订单").Filter = Filter End If
这是使用指南的查询窗口,请问这个怎么改成包含,还有多选又该怎么设计
|