总出现至少一个参数没有被指定值
黄豆159 2013-07-01 10:22:40 Public Sub Adddata()
On Error GoTo error
Dim sql As String
'连接数据库
sql = "INSERT INTO data " & "VALUES (" & Trim(Text1.Text) & ",'" & Trim(Text2.Text) & "'," & Trim(Text3.Text) & "','" & Trim(Text4.Text) & "," & Text5.Text & ") "
conn.Execute sql
'重新显示
Form1.Data_Show
'提示
MsgBox "添加成功!", vbInformation
'清空文本框
Text1.Text = ""
Text2.Text = ""
Text3.Text = ""
Text4.Text = ""
Text5.Text = ""
'设置焦点
Text1.SetFocus
Exit Sub
error:
MsgBox Err.Description & "Adddata", vbExclamation
End Sub