srec.RecordSource = "select * from LINGRU where 日期 between " & DTPicker1.Value & " and " & DTPicker2.Value//你的日期是什么类型的?
'数据库为SQL: srec.RecordSource = "select * from LINGRU where LINGRU.日期 between '"& DTPicker1.Value & "' and '"& DTPicker2.Value &"'" '数据库为ACCESS: srec.RecordSource = "select * from LINGRU where LINGRU.日期 between # "& DTPicker1.Value & " # and # " & DTPicker2.Value & " #"
srec.RecordSource = "select * from LINGRU where LINGRU.日期 between DTPicker1.Value and DTPicker2.Value 把这句话改成这样试一下: srec.RecordSource = "select * from LINGRU where 日期 between'"& DTPicker1.Value &"' and '"& DTPicker2.Value &"'"
srec.RecordSource = "select * from LINGRU where LINGRU.日期 between '"& DTPicker1.Value & "' and '"& DTPicker2.Value &"'"
'数据库为ACCESS:
srec.RecordSource = "select * from LINGRU where LINGRU.日期 between # "& DTPicker1.Value & " # and # " & DTPicker2.Value & " #"
把这句话改成这样试一下:
srec.RecordSource = "select * from LINGRU where 日期 between'"& DTPicker1.Value &"' and '"& DTPicker2.Value &"'"