Access中VB的问题,求!!!

来源:百度知道 编辑:UC知道 时间:2024/06/24 06:51:56
Private Sub 添加职员_Click()
On Error GoTo Err_添加职员_Click
Dim STemo As String
Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset
stemp = "Select * From 员工资料"
rs.Open stemp, CurrentProject.Connection, adOpenKeyset, adLockBatchOptimistic
If Me![职员ID] <> "" And Me![部门ID] <> "" And Me![姓名] <> "" And Me![身份证ID] <> "" Then

rs.AddNew

rs("职员ID") = Me![职员ID]
rs("部门ID") = Me![部门ID]
rs("姓名") = Me![姓名]
rs("性别") = Me![性别]
rs("籍贯") = Me![籍贯]
rs("年龄") = Me![年龄]
rs("民族") = Me![民族]
rs("身份证ID") = Me![身份证ID]
rs("家庭地址") = Me![家庭地址]
rs("家庭电话") = Me![家庭电话]
rs("手机号码") = Me![手机号码]
rs("电子邮箱") = Me![电子邮箱]
rs("备注") = Me![备注]

Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset
rs.Open "员工资料", CurrentProject.Connection, adOpenKeyset, adLockOptimistic
。。。。
。。。。

Set rs=Nothing(用 Me![备注]="" )

取消 Set rs=Nothing 这一行试试看.