Private Sub mnuDelete_Click() Dim Ret As Integer Ret = MsgBox("您确定要删除第" & DataGrid1.Columns(0).Text & "期的记录?", vbOKCancel, "提示信息") If Ret = vbOK Then Adodc1.Recordset.Delete On Error GoTo deleteFailure adodc1.recerdset.movepervious exit sub End If deleteFailure: MsgBox Err.Number & vbCrLf & Err.Description End Sub 一定是可以的,你再试试了!!
Private Sub mnuDelete_Click() Dim Ret As Integer Ret = MsgBox("您确定要删除第" & DataGrid1.Columns(0).Text & "期的记录?", vbOKCancel, "提示信息") If Ret = vbOK Then Adodc1.Recordset.Delete On Error GoTo deleteFailure
adodc1.recerdset.movepervious End If (再这里错) exit sub
deleteFailure: MsgBox Err.Number & vbCrLf & Err.Description End Sub 应该试这样的,我先前看错了
Dim Ret As Integer
Ret = MsgBox("您确定要删除第" & DataGrid1.Columns(0).Text & "期的记录?", vbOKCancel, "提示信息")
If Ret = vbOK Then
Adodc1.Recordset.Delete
On Error GoTo deleteFailure
adodc1.recerdset.movepervious
exit sub
End If
deleteFailure:
MsgBox Err.Number & vbCrLf & Err.Description
End Sub
一定是可以的,你再试试了!!
Dim Ret As Integer
Ret = MsgBox("您确定要删除第" & DataGrid1.Columns(0).Text & "期的记录?", vbOKCancel, "提示信息")
If Ret = vbOK Then
Adodc1.Recordset.Delete
On Error GoTo deleteFailure
adodc1.recerdset.movepervious
End If (再这里错)
exit sub
deleteFailure:
MsgBox Err.Number & vbCrLf & Err.Description
End Sub
应该试这样的,我先前看错了
2。加DOEvents 依然没用
过路人说的注册问题我不明白,请详细说明!
谢谢各位!
不明白你的话,可以说详细点吗?
如果你用datagrid控件绑定adodc1控件来显示记录的话,当你删掉了一条记录,其实这条记录并没有真正删除,只是作上了删除标记,但datagrid的当前行还是指向该记录,当然就出现出错提示了,你要作的就是刷新datagrid的显示,让它始终显示有效记录即可。