Dim cn As ADODB.Connection, rs As ADODB.RecordsetSet cn = New ADODB.Connection cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\1.mdb" Set rs = New ADODB.Recordset rs.Open "SELECT * FROM chsyy WHERE [date] BETWEEN #" & Format(start, "yyyy-mm-dd HH:nn:ss") & "# AND #" & Format(stop, "yyyy-mm-dd HH:nn:ss") & "#", cnSet MSHFlexGrid1.DataSource = rs
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\1.mdb"
Set rs = New ADODB.Recordset
rs.Open "SELECT * FROM chsyy WHERE [date] BETWEEN #" & Format(start, "yyyy-mm-dd HH:nn:ss") & "# AND #" & Format(stop, "yyyy-mm-dd HH:nn:ss") & "#", cnSet MSHFlexGrid1.DataSource = rs