Foxtable(狐表)用户栏目专家坐堂 → 我在窗口学习编写以下代码,提示错误


  共有1669人关注过本帖树形打印复制链接

主题:我在窗口学习编写以下代码,提示错误

帅哥哟,离线,有人找我吗?
有点甜
  1楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:版主 帖子:85326 积分:427815 威望:0 精华:5 注册:2012/10/18 22:13:00
  发帖心情 Post By:2018/3/20 9:02:00 [显示全部帖子]

改成这样

 

Dim nms() As String = {"ComboBox1","ComboBox2","ComboBox3","DateTimePicker1","DateTimePicker2"} '所有输入口使用STRING表示
Dim sps() As String = {"'","'","'","#","#"} '输入框使用'表示,日期使用#表示,双引号引用,逗号分开
Dim bjf() As String = {"=","=","=",">=","<="} '定义每个输入口搜索范围
Dim fds() As String = {"第02","第06","第05","年份日期","年份日期"}
Dim filter As String
For i As Integer = 0 To nms.Length -1
    If e.Form.Controls(nms(i)).Value IsNot Nothing Then
        If filter > "" Then
            filter = filter & " and "
        End If
        filter = filter & fds(i) & bjf(i) & sps(i) & e.Form.Controls(nms(i)).Value & sps(i)
    End If
Next
MessageBox.show(filter)
Tables("水质检测原始数据").filter = filter

e.form.controls("DateTimePicker1").Select() '返回输入口


 回到顶部