7,763
社区成员
发帖
与我相关
我的任务
分享
Private Sub Command3_Click()
If Text5.Text = Text6.Text Then
rs.Open "select * from student", conn, adOpenKeyset, adLockOptimistic
rs.AddNew
Trim(rs.Fields(0)) = " & Text1.Text & "
Trim(rs.Fields(1)) = " & Text1.Text & "
Trim(rs.Fields(2)) = " & Text1.Text & "
Trim(rs.Fields(3)) = " & Text1.Text & "
Trim(rs.Fields(4)) = " & Text1.Text & "
Trim(rs.Fields(5)) = " & Text1.Text & "
rs.Update
rs.Close
MsgBox "新增学生成功", , "提示"
Else
MsgBox "两次密码不一致,请重新输入", , "提示"
End If
Exit Sub
End Sub
If Text5.Text = Text6.Text Then
rs.Open "Select * From student Where sno='" & Text1.Text & "'", conn, adOpenKeyset, adLockOptimistic
If rs.EOF = True Then
rs.AddNew
rs.Fields(0) = Text1.Text
rs.Fields(1) = Text2.Text
rs.Fields(2) = Text3.Text
rs.Fields(3) = Text4.Text
rs.Fields(4) = Text7.Text
rs.Fields(5) = Text5.Text
rs.Update
rs.Close
MsgBox "新增学生成功", , "提示"
End If
Else
MsgBox "两次密码不一致,请重新输入", , "提示"
End If
Exit Sub
rs.Open "Select * From student Where sno='" & Text1.Text & "'", conn, adOpenKeyset, adLockOptimistic 还是有问题 3705错误 不允许打开If Text5.Text = Text6.Text Then
rs.Open "select * from student", conn, adOpenKeyset, adLockOptimistic
rs.AddNew
rs.Fields(0) = Trim(Text1.Text)
rs.Fields(1) = Trim(Text2.Text)
rs.Fields(2) = Trim(Text3.Text)
rs.Fields(3) = Trim(Text4.Text)
rs.Fields(4) = Trim(Text7.Text)
rs.Fields(5) = Trim(Text5.Text)
rs.Update
rs.Close
MsgBox "新增学生成功", , "提示"
Else
MsgBox "两次密码不一致,请重新输入", , "提示"
End If
Exit Sub
但还是实时错误'-2147217873(80040e2f)'
rs.Fields(0) = Trim(Text1.Text)