Ms访问UPDATE错误3144 [英] Ms access UPDATE error 3144
问题描述
大家好，
我创建了一个数据库作为检查系统。我能够输入数据，但更新数据有错误。我真的不知道错误在哪里。任何人都可以帮我解决问题。
UPDATE语句如下。
希望我的问题可以尽快解决。谢谢！
| CurrentDb.Execute" UPDATE tblCheckJobList" &安培; _ |
|             "SET CheckJobID =" &安培; Me.Text1& _ |
|             "，Date ='" &安培; Me.Text2& """ &安培; _ |
|             "，EnteredBy ='" &安培; Me.Text3& """ &安培; _ |
|             "，CustomerName ='" &安培; Me.Text4& """ &安培; _ |
|             "，JobRefNo ='" &安培; Me.Text5& """ &安培; _ |
|             "，SSO ='" &安培; Me.Text6& """ &安培; _ |
|             "，TrayNo ='" &安培; Me.Text7& """ &安培; _ |
|             "，CommittedDate ='" &安培; Me.Text8& """ &安培; _ |
|             "，JobStatus =" &安培; Me.Combo9& "" &安培; _ |
|             "，GlobalLab =" &安培; Me.Combo10& "" &安培; _ |
|             "，FrameType =" &安培; Me.Combo11& "" &安培; _ |
|             "，CSRemarks ='" &安培; Me.Text12& """ &安培; _ |
|             "，CEFRemarks ='" &安培; Me.Text13& """ &安培; _ |
|             "，Trip ='" &安培; Me.Frame14& """ &安培; _ |
|             "，WHERE CheckJobID =" &安培; Me.Text1.Tag |
关键字Date是保留字（函数）。您可能需要将其括在括号内（例如[Date]）或重命名。通常情况下，最好重命名保留字。
顺便说一句，如果您的列日期是实际日期数据类型，那么值将是需要用哈希字符而不是单引号括起来。
Hi all expert,
I created a database as a checking system. I able to enter data but for update data got error. i really don't know where is the error. can anyone help me to solve the problem.
The UPDATE statement as below.
Wish my problem can be solve asap. Thanks!
| CurrentDb.Execute "UPDATE tblCheckJobList " & _ |
| "SET CheckJobID=" & Me.Text1 & _ |
| ", Date='" & Me.Text2 & "'" & _ |
| ", EnteredBy='" & Me.Text3 & "'" & _ |
| ", CustomerName='" & Me.Text4 & "'" & _ |
| ", JobRefNo='" & Me.Text5 & "'" & _ |
| ", SSO='" & Me.Text6 & "'" & _ |
| ", TrayNo='" & Me.Text7 & "'" & _ |
| ", CommittedDate='" & Me.Text8 & "'" & _ |
| ", JobStatus=" & Me.Combo9 & "" & _ |
| ", GlobalLab=" & Me.Combo10 & "" & _ |
| ", FrameType=" & Me.Combo11 & "" & _ |
| ", CSRemarks='" & Me.Text12 & "'" & _ |
| ", CEFRemarks='" & Me.Text13 & "'" & _ |
| ", Trip='" & Me.Frame14 & "'" & _ |
| ", WHERE CheckJobID=" & Me.Text1.Tag |
The keyword Date is a reserved word (function). You would either need to enclose it within brackets (e.g. [Date]) or rename it. Typically it's better to rename reserved words.
Access 2007 reserved words and symbols
BTW, if your column Date is an actual Date data type then the value would need to be enclosed between hash characters instead of single quotes.
这篇关于Ms访问UPDATE错误3144的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
