Access 2013插入/更新

debugcn 发表于 Dev

纪子

我有一个添加用户的表单。

我可以添加，删除表中的行，但是如果用户已经存在，我会假装更新。

我的目标是按子表单中的行进行编辑。但是每次我按更新时，都会给我一个错误。

查询表达式中的运行时错误'3075'语法错误运算符。

我的动作代码是这个

Private Sub cmdAdd_Click()
    'quando se carrega em Adicionar há 2 opcoes
    '1-Insert
    '2-Update
    If Me.txtuserid.Tag & "" = "" Then

        '1
        CurrentDb.Execute "INSERT INTO user(userid, username, userfunction, usercc) " & _
                " VALUES(" & Me.txtuserid & ",'" & Me.txtusername & "','" & Me.txtuserfun & "','" & Me.txtusercc & "')"
     Else
     '2
     CurrentDb.Execute "UPDATE user " & _
            " SET userid=" & Me.txtuserid & _
            ", username=" & Me.txtusername & "'" & _
            ", userfunction =" & Me.txtuserfun & "'" & _
            ", usercc =" & Me.txtusercc & "'" & _
            " WHERE userid =" & Me.txtuserid.Tag
      End If
    'clear fields
    cmdClear_Click
    'refresh
    SubForm1.Form.Requery
End Sub

我做错了什么？

普拉文

您是否错过'了更新声明？

CurrentDb.Execute "UPDATE user " & _
        " SET userid=" & Me.txtuserid & _
        ", username='" & Me.txtusername & "'" & _
        ", userfunction ='" & Me.txtuserfun & "'" & _
        ", usercc ='" & Me.txtusercc & "'" & _
        " WHERE userid =" & Me.txtuserid.Tag

本文收集自互联网，转载请注明来源。

如有侵权，请联系[email protected] 删除。