作者mdki19 (JL)
看板Visual_Basic
标题[VB6 ] keyword
时间Mon May 4 16:57:51 2009
请问日期如果是"2008/9/4 上午 12:21:42"
为什麽我输入"2008/9/4"至"2008/9/4"搜寻不到
code:
If (Text7.Text = "" Or Text8.Text = "") Then
ret = MsgBox("请输入搜寻值时间", 49, "输入搜寻值")
Exit Sub
End If
rs.Filter = "time>=#" & Text7.Text & "# And time<=#" & Text8.Text & "#"
If rs.RecordCount = 0 Then
ret = MsgBox("无资料", 49, "搜寻结果")
End If
-----------------------------------------------
请问AA = "NH4OH;11V11_ST2"
但是我只要搜寻"11V11"就可以搜寻到
该怎麽做呢??
code:
If Text6.Text = "" Then
ret = MsgBox("请输入搜寻值", 49, "输入搜寻值")
Exit Sub
End If
rs.Filter = "AA='" & Text6.Text & "'"
If rs.RecordCount = 0 Then
ret = MsgBox("无资料", 49, "搜寻结果")
End If
--------------------------------------------------
谢谢
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 61.31.134.88
1F：推 ClubT:2008/9/4指的是2008/9/4 00:00:00 所以要改成 9/4 - 9/5 05/05 12:35
2F：→ mdki19:谢谢C大 时间那题以解决 05/06 09:12