我想在单击COMMAND时可以将数据加到数据库中,但是当添加时总会覆盖第一条记录这是代码请帮忙看看

来源:百度知道 编辑:UC知道 时间:2024/06/08 23:33:56
Private Sub Command1_Click()
WebBrowser1.Navigate Combo1.Text
Dim i%
Adodc1.Recordset.MoveFirst
For i = 1 To Adodc1.Recordset.RecordCount + 1
If Combo1.Text = Text1.Text Then GoTo b
Adodc1.Recordset.MoveNext
If Adodc1.Recordset.EOF Then Adodc1.Recordset.MoveLast
Next i
Adodc1.Refresh
Adodc1.Recordset.AddNew
Adodc1.Recordset.Fields("地址") = Combo1.Text
'Adodc1.Recordset.Update
'Adodc1.Recordset.MoveLast
Adodc1.Refresh
b:
End Sub

试试看

Private Sub Command1_Click()
WebBrowser1.Navigate Combo1.Text
Dim i%
Adodc1.Recordset.MoveFirst
For i = 1 To Adodc1.Recordset.RecordCount + 1
If Combo1.Text = Text1.Text Then GoTo b
Adodc1.Recordset.MoveNext
If Adodc1.Recordset.EOF Then Adodc1.Recordset.MoveLast
Next i

Adodc1.Recordset.AddNew
Adodc1.Recordset.Fields("地址") = Combo1.Text
Adodc1.Recordset.Update
b:
End Sub