In lesson 4, I get the following error message. I searched the internet for how to solve this. I used both codes but keep running into the same issue. I also used Richard's original codes, but those give an error as well. I should mention that I currently use Microsoft 365, but this shouldn't have any influence.
Richard VerschoorOP
@Reply 5 months ago
Kevin Robertson
@Reply 5 months ago
What's the error message?
Richard VerschoorOP
@Reply 5 months ago
The code docmd.runsql s . stops and does not continue updating the testresultT
Donald Blackwell
@Reply 5 months ago
Try putting:
MsgBox S
before
DoCmd.RunSQL S
and verify what is being passed to RunSQL.
Other than that, we'll need the actual error number and/or statement that pops up
Richard VerschoorOP
@Reply 5 months ago
Error 3144 during execution. The UPDATE instruction contains a syntax error.
Richard VerschoorOP
@Reply 5 months ago
Juan Rivera
@Reply 5 months ago
wild shot here try this one.
Dim S As String
Dim strGrade As String
'Convert Grade to SQL-safe decimal format
strGrade = Replace(CStr(Grade), ",", ".")
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Developer 10.