I am building a strSQL string and then executing as follows; CurrentDb.Execute strSQL
I attach the strSQL value but it should be fine as it has worked in the past. It inserts a record into a table.
However, now the CurrentDb.Execute does NOTHING! It does not display any error and I have used F8 to step through it. No sign of any errors but it has suddenly stopped working.
MsgBox "before execute"
Insert into tblCustomers(CustomerName,CustomerPhone,CompanyName,Add1,Add2, Add3, PostCode, Email, GeneralComments, ReportedBy, EngineerorsubCONtractor, merchant, windowcount, faultywindowcount,status,recallid,datereported,dateviewed,expectedcompletion) values ("ROBERT GREEN cust - DARREN PURP (recall)", "077100557 ", "", "LEE ROAD, CRATLEY, STETSTOWN", "Backley", "", "", "","***DATE: 26/09/2011 ***Windows ID Code ***PROBLEM:INTEGRAL BLIND STICKING ***SERVICE NUM: 2041 ***NOTES : glass ordered REF Glenn *** COMMENTS: ", 1,1,1,0,1,1,188,#10/21/2011 16:43:28#,#10/21/2011 16:43:28#,#11/04/2011 16:43:28#)