Strsql = "select * from 预约者 where 预约时间 = #" & Format(dateadd("m",15,Now), "yyyy/mm/dd hh:mm:ss") & "# and between #" & Format(Now, "yyyy/mm/dd hh:mm:ss") & "#"
Strsql = "select * from 预约者 where 预约时间 between #" & Format(dateadd("m",15,Now), "yyyy/mm/dd hh:mm:ss") & "# and #" & Format(Now, "yyyy/mm/dd hh:mm:ss") & "#"
Dim cn As New ADODB.Connection Dim rs As New ADODB.Recordset Dim Strsql As String rs.CursorLocation = adUseClient ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\sAnKes\Desktop\data.mdb;Persist Security Info=False" ' cn.Open ConnectionString Strsql = "select * from 预约者 where 预约时间 between #" & Format(DateAdd("m", 15, Now), "yyyy/mm/dd hh:mm:ss") & "# and #" & Format(Now, "yyyy/mm/dd hh:mm:ss") & "#" rs.Open Strsql, cn, 3, 3 If rs.RecordCount > 0 Then frmTip.Show Else Exit Sub End If
Strsql = "select * from 预约者 where 预约时间 between #" & Format(DateAdd("n", 15, Now), "yyyy/mm/dd hh:mm:ss") & "# and #" & Format(Now, "yyyy/mm/dd hh:mm:ss") & "#"
sql=" select m_name,m_time from mytable where m_time between '" dateadd("m",15,now) & "' and '" & now & "' "显示 s="还有" & datediff("m",rs.fields(1),now) & "分钟" & rs.fields(0) & "就应该报道"
rs.Open Strsql, cn, 3, 3总是提示类型不对,
数据库设置是日期格式!
查询记录,例如2009-9-12 10:45每30秒查询一次,如果查询所得的记录RecordCount> 0 则弹出消息窗口。
如果没有记录则退出过程。如果要提前15分钟呢。查询条件应该怎么写呢?
Dim rs As New ADODB.Recordset
Dim Strsql As String
rs.CursorLocation = adUseClient
ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\sAnKes\Desktop\data.mdb;Persist Security Info=False" '
cn.Open ConnectionString
Strsql = "select * from 预约者 where 预约时间 between #" & Format(DateAdd("m", 15, Now), "yyyy/mm/dd hh:mm:ss") & "# and #" & Format(Now, "yyyy/mm/dd hh:mm:ss") & "#"
rs.Open Strsql, cn, 3, 3
If rs.RecordCount > 0 Then
frmTip.Show
Else
Exit Sub
End If