If dtBegin > dtEnd Then MsgBox "起始日期不能大于终止日期,请重新选择!", vbInformation: Exit Sub
Adodc1.RecordSource = "select * from Test_resolve where ReDate BETWEEN '" & dtBegin.Value & _
"' AND '" & dtEnd.Value & "'"
Set DataGrid1.DataSource = Adodc1
Adodc1.RecordSource = "select * from Test_resolve where ReDate BETWEEN '" & dtBegin.Value & _
"' AND '" & dtEnd.Value & "'"
Set DataGrid1.DataSource = Adodc1
Adodc1.RecordSource = "select * from Test_resolve where ReDate BETWEEN '" & dtBegin.Value & _
"' AND '" & dtEnd.Value & "'"
'数据库为ACCESS:
Adodc1.RecordSource = "select * from Test_resolve where ReDate BETWEEN #" & dtBegin.Value & _
"# AND #" & dtEnd.Value & "#"