運行以下命令時出現運行時錯誤：
mySQL = "INSERT INTO incidentlog (mon, yr, observation) VALUES (" & Me.Combo37.Column(0) & ", " & Me.Combo39.Column(0) & ", " & Me.Combo10.Column(0) & ": " & Me.Text12 & "" & vbCrLf & "--" & Me.Combo35 & "" & Me.Combo37 & "" & Me.Combo39 & "/" & Me.Combo18 & "/" & Me.Text16 & "/COR " & Me.Text21 & " " & Me.Combo25.Column(2) & ")"
Debug.Print mySQL
DoCmd.RunSQL mySQL
除錯列印正確，但我似乎無法弄清楚問題出在哪里。combo35、combo39 和 text16 都是數字欄位。
除錯列印（編輯資訊輸出）：
INSERT INTO incidentlog (mon, yr, observation) VALUES (Jan, 2022, PO-02: EDITED OUT.
--01Jan2022/EDITED OUT/0700/COR my notes here USER)
uj5u.com熱心網友回復：
由于最后一個欄位 ,observation是文本，因此您需要將其用單引號括起來：
mySQL = "INSERT INTO incidentlog (mon, yr, observation)
VALUES ("
& Me.Combo37.Column(0) & ", "
& Me.Combo39.Column(0) & ", '"
& Me.Combo10.Column(0) & ": " & Me.Text12 & "" & vbCrLf & "--" & Me.Combo35 & "" & Me.Combo37 & "" & Me.Combo39 & "/" & Me.Combo18 & "/" & Me.Text16 & "/COR " & Me.Text21 & " " & Me.Combo25.Column(2)
& "')"
轉載請註明出處，本文鏈接：https://www.uj5u.com/qita/514543.html