Code: Select all
Private Sub CmdUpdateRecord_Click()
DoCmd.RunSQL "Update tblEST SET EnquiryInfo WHERE JobID=me.txtjobid"
End Sub
Kind Regards
Code: Select all
Private Sub CmdUpdateRecord_Click()
DoCmd.RunSQL "Update tblEST SET EnquiryInfo WHERE JobID=me.txtjobid"
End Sub
Code: Select all
Private Sub CmdUpdateRecord_Click()
DoCmd.RunSQL "Update tblEST SET EnquiryInfo=Null WHERE JobID=" & Me.txtJobID
End Sub
Code: Select all
Private Sub CmdUpdateRecord_Click()
DoCmd.RunSQL "Update tblEST SET EnquiryInfo=" & Chr(34) & Me.txtEnquiryInfo & Chr(34) & " WHERE JobID=" & Me.txtJobID
End Sub
Code: Select all
DoCmd.RunSQL "Update tblEST SET Status='A' WHERE JobID=" & Me.JobID
Code: Select all
DoCmd.RunSQL "Update tblEST SET [A-Date]=Date() WHERE JobID=" & Me.JobID
Here is another useful quick guide to SQL for Access (with syntax samples)D Willett wrote:Got it !!!
Found a useful link to study which should give me some help with future problems hopefully...
https://www.fmsinc.com/MicrosoftAccess/ ... SQL_Syntax
Once again thanks