原来代码是用acess97的,所以用的还是dao数据库,有段代码需要删除指定日期,指定次数的那段记录,我这样写,可是报错。
Private Sub DataDel()
Dim dbs As Database
Dim MySql As String
Dim rst As Recordset
Set dbs = OpenDatabase(datareal.DatabaseName)
MySql = "delete from RealData where TestDay=" & Format(DateTimePicker1.Value, "yyyymmdd") & " and TestTimes=" & Combo1.List(Combo1.ListIndex)
Set rst = dbs.OpenRecordset(MySql, dbOpenDynaset, , dbOptimistic)
rst.Delete
rst.Update
rst.Close
dbs.Close
End Sub报实时错误'3001',无效的参数量。
我数据库不熟悉,请帮我改改看吧?
Private Sub DataDel()
Dim dbs As Database
Dim MySql As String
Dim rst As Recordset
Set dbs = OpenDatabase(datareal.DatabaseName)
MySql = "delete from RealData where TestDay=" & Format(DateTimePicker1.Value, "yyyymmdd") & " and TestTimes=" & Combo1.List(Combo1.ListIndex)
Set rst = dbs.OpenRecordset(MySql, dbOpenDynaset, , dbOptimistic)
rst.Delete
rst.Update
rst.Close
dbs.Close
End Sub报实时错误'3001',无效的参数量。
我数据库不熟悉,请帮我改改看吧?
各位大侠帮下忙了,弄了半天搞不出来。