一段ADO连接access数据库添加数据的代码,不知道哪错了。
来源:百度知道 编辑:UC知道 时间:2024/06/30 12:59:34
如果textbox内没有数据,就会弹出"带 * 号为必填项",
但是填入数据后再点击就没有反应了。也无法将数据写入数据库。不知道什么原因,望指教!~
Private Sub cmdAdd_Click()
Dim sc As Integer
If Not Testtxt(txtNo.Text) Or Testtxt(txtName.Text) Or Testtxt(txtSex.Text) Or Testtxt(txtBookTime.Text) Or Testtxt(txtTel.Text) Or Testtxt(txtEnrolTime.Text) Then
MsgBox "带 * 号为必填项", vbOKOnly + vbExclamation, "警告"
txtNo.SetFocus
Exit Sub
End If
sc = MsgBox("确实要添加这条记录吗?", vbOKCancel, "提示信息")
If sc = 1 Then
Dim conn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim Str1 As String
Dim Str2 As String
Dim Str3 As String
Str1 = "rovider=Microsoft.Jet.OLEDB.4.0;"
Str2 = "Data Source=/data.mdb;"
Str3 = "Jet OLEDBatabase Password=
但是填入数据后再点击就没有反应了。也无法将数据写入数据库。不知道什么原因,望指教!~
Private Sub cmdAdd_Click()
Dim sc As Integer
If Not Testtxt(txtNo.Text) Or Testtxt(txtName.Text) Or Testtxt(txtSex.Text) Or Testtxt(txtBookTime.Text) Or Testtxt(txtTel.Text) Or Testtxt(txtEnrolTime.Text) Then
MsgBox "带 * 号为必填项", vbOKOnly + vbExclamation, "警告"
txtNo.SetFocus
Exit Sub
End If
sc = MsgBox("确实要添加这条记录吗?", vbOKCancel, "提示信息")
If sc = 1 Then
Dim conn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim Str1 As String
Dim Str2 As String
Dim Str3 As String
Str1 = "rovider=Microsoft.Jet.OLEDB.4.0;"
Str2 = "Data Source=/data.mdb;"
Str3 = "Jet OLEDBatabase Password=
MsgBox "带 * 号为必填项", vbOKOnly + vbExclamation, "警告"
txtNo.SetFocus
Exit Sub
End If
里的Exit Sub去掉行不行
检查下数据类型和你数据库中的数据类型是不是有出入