VB6中 报语法错误（操作符丢失）

[qqww09633]

各位前辈，我想从当前表中筛选出某个时间段的数据，时间在text2和text3中，点Alarm Seach时报语法错误（操作符丢失），错误如下

代码为

Private Sub Command4_Click()
StrSQL = "select * from AlarmHistory where start time Between #" & Text2.Text & "# and #" & Text3.Text & "#"
If Rs.State <> 0 Then Rs.Close
    Rs.Open StrSQL, Conn, 1, 3
    If Rs.EOF Then
    
    Else
    DataGrid1.AllowUpdate = True
    Timer2.Enabled = True
    End If
End Sub

这个怎么解决啊？？

[worldy]

Private Sub Command4_Click() StrSQL = "select * from AlarmHistory where start time Between #" & Text2.Text & "# and #" & Text3.Text & "#" If Rs.State <> 0 Then Rs.Close Rs.Open StrSQL, Conn, 1, 3 If Rs.EOF Then Else DataGrid1.AllowUpdate = True Timer2.Enabled = True End If End Sub 红色部分要么是StartTime 要么应该写成：[Start Time]

[worldy]

k看了你的表，应该是 StrSQL = "select * from AlarmHistory where [start time] Between #" & Text2.Text & "# and #" & Text3.Text & "#"

[qqww09633]

引用 2 楼 worldy 的回复:

k看了你的表，应该是
StrSQL = "select * from AlarmHistory where [start time] Between #" & Text2.Text & "# and #" & Text3.Text & "#"

试了一下你说的两种方法，还是会出错，是否还是其他问题啊

[qqww09633]

引用 2 楼 worldy 的回复:

k看了你的表，应该是 StrSQL = "select * from AlarmHistory where [start time] Between #" & Text2.Text & "# and #" & Text3.Text & "#"

不好意思，是我自己把表的名称写错了，非常感谢worldy啊