加好友 发短信
等级:幼狐
帖子:142
积分:1115
威望:0
精华:0
注册:2017/4/21 9:36:00
|
模糊查询代码错误 Post By:2017/11/7 14:51:00 [只看该作者]
老师好,我用了帮助文档里面关于模糊查询的这一段代码,但是测试的时候输入数据时表中却筛选不出任何数据,求解
Dim txt As
String = e.Form.Controls("TextBox1").Text Dim tbl As Table = Tables("窗口1_Table1") If txt = "" Then tbl.Filter = "" Else txt = "'%" & txt & "%'" tbl.Filter = "客户ID Like " & txt & " Or 公司名称 Like " & txt &
" Or 地址 Like " & txt
& " Or 联系人 Like "
& txt End
If
|
|