Private Sub Comsave_Click()
Dim olid As String
cnn.ConnectionString = "provider=Microsoft.Jet.OLEDB.4.0;Data Source =人事档案管理.mdb;"
cnn.Open
cmd.ActiveConnection = cnn
Dim sqlstmt As String
olid = Adodc1.Recordset.Fields(0)
sqlstmt = "UPDATE 基本档案 SET 姓名 = ' " + Trim(Txtname.Text) + " ' where 职工编号=" + Trim(olid)
cmd.CommandText = sqlstmt
cmd.Execute
MsgBox "数据已保存!", vbOKOnly
Frenshi.Adodc1.Refresh
Txtid.Text = ""
Txtname.Text = ""
txtbumen.Text = ""
Set rs = Nothing
cnn.Close
End Sub运行后老是提示:实时错误
至少一个参数没有被指定值
where 职工编号後的“=”似乎是全角的,改為半角的試試
where 职工编号 =" + Trim(olid)
sqlstmt = "UPDATE 基本档案 SET 姓名 =N ' " + Trim(Txtname.Text) + " ' where 职工编号=" + Trim(olid)
中文的栏位内容前要加'N'