……
With e.Form.Controls("结束")
If .Value IsNot Nothing Then
If Filter >"" Then
Filter = Filter & " And "
End If
Filter = Filter & "记录时间 <= #" & .Value & "#"
End If
End With
Dim txt As String = e.Form.Controls("TextBox1").Text
If txt > "" Then
If Filter >"" Then
Filter = Filter & " And "
End If
txt = "'%" & txt & "%'"
Filter = Filter & "(店铺名称 Like " & txt & " Or 单号 Like " & txt & " Or 处理人 Like " & txt & " Or 发货仓库 Like" & txt & " Or 物流公司 Like" & txt & " Or 赠送SKU Like" & txt & " Or 客户姓名 Like" & txt & " Or 系统单号 Like" & txt & " Or 产品类别 Like " & txt & " Or 配件SKU Like " & txt & " Or 产品SKU Like " & txt & " Or 联系方式 Like " & txt & " Or 追踪号 Like " & txt & " Or 处理方式 Like " & txt & " Or 备注 Like " & txt & " Or 回访 Like" & txt & " Or 状态 Like" & txt & " Or 寄送地址 Like " & txt & ")"
End If
If Filter > "" Then
Tables("Table_3").Filter = Filter
End If
加好友 
发短信
Post By：2021/9/8 10:01:00 [显示全部帖子]
