这是我的代码,每次事件触发时只能删除1条记录,而不是删除所有符合条件的,请高手帮忙看看
Private Sub Form_Current()
Dim rs As ADODB.Recordset
Dim strSQL As String
On Error GoTo HandleError
Set rs = New ADODB.Recordset
strSQL = "SELECT ALL * FROM 客户 " _
& "WHERE (Date() - [订货时间]) > " _
& 3
rs.Open strSQL, CurrentProject.Connection, adOpenDynamic, adLockOptimistic
With rs
If Not .EOF Then
'Delete the record:
.Delete
End If
End With
ExitHere:
rs.Close
Set rs = Nothing
Exit Sub
HandleError:
MsgBox Err.Description
Resume ExitHere
End Sub
access操作数据库一般有几种方法?
追答ado ,doa ,系统内置函数,一般就用这3种
追问我使用的是ado,你答案的是?
还有那个比较方便
ado 你写得是对的,
With rs
Do Until rs.EOF
.Delete
.MoveNext
Loop
End With
没有方便与不方便之说,只有习惯问题。有的用多种方法都可以实现,看你怎么用而已