此主题相关图片如下：捕获.png

筛选这两个时间之间的数据代码如何写

代码写在查询按钮里

这两个时间是可以改的

谢谢

Dim t1 As Date
Dim t2 As Date

Tables("表A").Filter = "案发时间 >= #" & t1 & "# and 案发时间 <= #" & t2 & "#"

我要将上面的情况放在下面的代码中,请帮我修改一下下,谢谢

Dim Filter As String
With e.Form.Controls("TextBox8")
    If .Value IsNot Nothing Then
        Filter = "编号 = \'" & .Value & "\'"
    End If
End With
With e.Form.Controls("TextBox7")
    If .Value IsNot Nothing Then
        Filter = "车辆基本情况_车牌号码 = \'" & .Value & "\'"
    End If
End With
With e.Form.Controls("ComboBox5")
    If .Value IsNot Nothing Then
        If Filter > "" Then
            Filter = Filter & " And "
        End If
        Filter = Filter & "车辆基本情况_车牌颜色 = \'" & .Value & "\'"
    End If
End With
With e.Form.Controls("ComboBox6")
    If .Value IsNot Nothing Then
        Filter = "案件状态 = \'" & .Value & "\'"
    End If
End With
With e.Form.Controls("DateTimePicker2")
    If .Value IsNot Nothing Then
        Filter = "违章基本情况_违章时间 >= \'" & .Value & "\'"
    End If
End With
With e.Form.Controls("DateTimePicker3")
    If .Value IsNot Nothing Then
        Filter = "违章基本情况_违章时间 <= \'" & .Value & "\'"
    End If
End With
If Filter > "" Then
    Tables("车辆违章表").Filter = Filter
End If

具体情况如下图: