Foxtable(狐表)用户栏目专家坐堂 → [求助]查询结果在窗口重新生成一个表


  共有2352人关注过本帖平板打印复制链接

主题:[求助]查询结果在窗口重新生成一个表

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


加好友 发短信
等级:童狐 帖子:238 积分:1838 威望:0 精华:0 注册:2014/7/1 8:56:00
[求助]查询结果在窗口重新生成一个表  发帖心情 Post By:2016/1/31 22:55:00 [只看该作者]

窗口中有一个[查询]控件,其代码为:

Dim Filter As String
With e.Form.Controls("TextBox1")
    If .Value IsNot Nothing Then
        Filter = "clxx_lphm = '" & .Value & "'"
    End If
End With
With e.Form.Controls("ComboBox1")
    If .Value IsNot Nothing Then
        If Filter > "" Then
            Filter = Filter & " And "
        End If
        Filter = Filter & "clxx_cpys = '" & .Value & "'"
    End If
End With
With e.Form.Controls("DateTimePicker1")
    If .Value IsNot Nothing Then
        If Filter >"" Then
            Filter = Filter & " And "
        End If
        Filter = Filter & "jbxx_jcsj >= #" & .Value & "#"
    End If
End With
With e.Form.Controls("DateTimePicker2")
    If .Value IsNot Nothing Then
        If Filter >"" Then
            Filter = Filter & " And "
        End If
        Filter = Filter & "jbxx_jcsj <= #" & .Value & "#"
    End If
End With
With e.Form.Controls("ComboBox2")
    If .Value IsNot Nothing Then
        If Filter > "" Then
            Filter = Filter & " And "
        End If
        Filter = Filter & "ajclqh_tijiaoqh = '" & .Value & "'"
    End If
End With
If Filter > "" Then
    Tables("ybchengxu").Filter = Filter
End If

 

要求:按照上面的查询代码查到的结果重新生成一个新表在窗口内显示,显示的列名不跟“ybchengxu”表中的列名一样,列名由代码来指定(窗口的表不绑定任何表)

 

请问大侠们,这个代码应如何写,请指教,谢谢!


 回到顶部