Did you fix the Me.Dirty = True to = False?
What is the purpose of the If that follows? You are checking Me.Q123 and setting MyComm to two different values. Obviously only the second value remains
Why are you storing the same data in multiple tables?
Suggest talk to your bosses and clarify, can understand data but cannot see why they would object to object and field names.
The problem is if you have a problem and it is related to spelling or object type and you say you have a problem and give a different spelling - or create typos because you don't copy paste, that just wastes everyone's time because the focus is on that and not the real issue.
The other problem is because you change names - you started with Form_Frm_ABC, then changed to frm_MainForm and then you say things like 'Me.Name = Form 3, this is not Form 1'.
Hi @CJ_London I agree with you. Typos are creating more problems which did not exist in real place.
I did not realize this 'that just wastes everyone's time because the focus is on that and not the real issue.'
My apologies, it is more irritating that the actual problem. Will take care going forward.
Have a nice day ahead.
The syntax changes according to whether the field being updated is numeric, a string or a date. It there are spaces in your field names you need to include square brackets around the [field name]
As already mentioned, I would include extra spaces. Adding spaces around the equals signs as below may make a difference.
Why don't you try to create an update query in the design pane, and then view it as SQL. That will show you what the SQL should look like. Try a simpler query first, and build up to more complicated one.
The line I quoted can be error trapped, which may help
Code:
on error goto updatefail
CurrentDb.Execute "Update MyTabe set ShortInfo='" & Me.Q123 & "', QAZ='" & Me.QAZ_ID & "', MyStatus=" & Me.WSX & " Where MyID=" & Form!frm_Second.MyID, dbfailonerror
exit sub
updatefail:
msgbox "Error with Execute" & vbcrlf & _
"Error: " & err & " Desc: " & err.description
Hi @Pat Hartman , @Minty , @gemma-the-husky , @MajP , @The_Doc_Man@ebs17@CJ_London
Thanks a lot for your help.
At the moment am trying new Sub to update the records.
Not trying to resolve bug in existing code.
New code seems to be working for me.
Please close this thread for as of now.
Will come back when required.
Have a nice day ahead.
SqlDebugPrint
With this add-in you can speed up and improve the display and checking of the generated SQL statement. In the case of action queries, a transaction ensures that no data in the table is changed as a result of the check process. Use in code after installation:
Code:
SqlDebug strSQL
However, one could also use real parameter queries and thus avoid such formatting problems.
