我做了一个注册新用户的窗体,按CmdSure把输入的内容提交,我用data控件连接数据库,下面是一段程序:
Private Sub CmdSure_Click()
Dim rsuseradd As New ADODB.Recordset
rsuseradd.Open "select * from useradd", fCnn, adOpenStatic, adLockOptimistic
rsuseradd.AddNew
rsuseradd("username") = Trim(TxtName.Text)
rsuseradd("userposition") = Trim(ComPosition.Text)
rsuseradd("section") = Trim(ComSection.Text)
rsuseradd("idnum") = Val(TxtId.Text)
rsuseradd("usernote") = Trim(TxtNote.Text)
If TxtPassword1.Text = TxtPassword2.Text Then
rsuseradd("password") = Trim(TxtPassword1.Text)
Else
MsgBox "ÊäÈëÃÜÂëÓë֮ǰ²»Ò»Ö£¬ÇëÔÙ´ÎÊäÈë", vbExclamation, "È·¶¨"
TxtPassword1.SetFocus
rsuseradd.Update
rsuseradd.Close
End If
End Sub
运行后出现:参数不正确,或不在范围内或与其它参数冲突,怎么回事?
Private Sub CmdSure_Click()
Dim rsuseradd As New ADODB.Recordset
rsuseradd.Open "select * from useradd", fCnn, adOpenStatic, adLockOptimistic
rsuseradd.AddNew
rsuseradd("username") = Trim(TxtName.Text)
rsuseradd("userposition") = Trim(ComPosition.Text)
rsuseradd("section") = Trim(ComSection.Text)
rsuseradd("idnum") = Val(TxtId.Text)
rsuseradd("usernote") = Trim(TxtNote.Text)
If TxtPassword1.Text = TxtPassword2.Text Then
rsuseradd("password") = Trim(TxtPassword1.Text)
Else
MsgBox "ÊäÈëÃÜÂëÓë֮ǰ²»Ò»Ö£¬ÇëÔÙ´ÎÊäÈë", vbExclamation, "È·¶¨"
TxtPassword1.SetFocus
rsuseradd.Update
rsuseradd.Close
End If
End Sub
运行后出现:参数不正确,或不在范围内或与其它参数冲突,怎么回事?
解决方案 »
- 关于自定义类型,急急急!!
- 如何向shtml提交表单
- 如何实现一个text中不同的字母不同的颜色
- 水晶报表打印完全页
- 为什么啊???????????????????
- 我用Instr()函数怎么出问题了?
- 请问如何制作类似于WINAMP中“选项设置”的树型样式?
- 请问装了VB SP5包不包括SP1,2,3,4啊?我装补丁的时候要不要从SP1,开始装起啊,我有SP1,SP2,SP3,SP4
- 怎样对parsdoxi数据库添加插入数据
- 我用VB+ACCESS2000做了一个程序(一共才两个窗体,里面用到了ADO控件,Datagrid控件,maskedbox)打包以后居然有二十几MB,请问有哪些文
- 关于VB自带打包程序的问题
- VB+access,怎样修改记录?
Private Sub CmdSure_Click()
Dim rsuseradd As New ADODB.Recordset
rsuseradd.Open "select * from useradd", fCnn, adOpenStatic, adLockOptimistic
rsuseradd.AddNew
rsuseradd("username") = Trim(TxtName.Text)
rsuseradd("userposition") = Trim(ComPosition.Text)
rsuseradd("section") = Trim(ComSection.Text)
rsuseradd("idnum") = Val(TxtId.Text)
rsuseradd("usernote") = Trim(TxtNote.Text)
If TxtPassword1.Text = TxtPassword2.Text Then
rsuseradd("password") = Trim(TxtPassword1.Text)
Else
MsgBox “输入密码与之前不一致,请再次输入”,vbclamation“确定”
TxtPassword1.SetFocus
rsuseradd.Update
rsuseradd.Close
End If怎么更正程序??
Private Sub CmdSure_Click()
Dim rsuseradd As New ADODB.Recordset
rsuseradd.Open "select * from useradd", fCnn, adOpenStatic, adLockOptimistic
rsuseradd.AddNewrsuseradd("username") = Trim(TxtName.Text)
rsuseradd("userposition") = Trim(ComPosition.Text)
rsuseradd("section") = Trim(ComSection.Text)
rsuseradd("idnum") = Val(TxtId.Text)
rsuseradd("usernote") = Trim(TxtNote.Text)If TxtPassword1.Text = TxtPassword2.Text Then
rsuseradd("password") = Trim(TxtPassword1.Text)
Else
MsgBox “输入密码与之前不一致,请再次输入”,vbclamation“确定”
TxtPassword1.SetFocus
End If
rsuseradd.Update
rsuseradd.Close