Hi there. This is my first time using a forum so please forgive me if I have posted in the wrong area. I am having issues with the below code. It used to work, and now suddenly it won't. I have checked with out IT department and there were no upgrades or changes made last night to our systems. What this code does is take information from text boxes on a form and add them to an existing table:
Dim strSQL As String
strSQL = "INSERT INTO Tbl_ClosedActivities (ActivityNumber, Goal, CorporateDivisionalPriorities, InitiativesActivities, KeyOutcomes, FunctionalArea, Strategy, Approver, Owner, ActionsTaken, DocumentumHyperlink, Comments, FirstDueDate, Frequency, DateClosed) VALUES ('" & ActivityNumber.Value & "', '" & Goal.Value & "', '" & CorporateDivisionalPriorities.Value & "', '" & InitiativesActivities.Value & "', '" & KeyOutcomes.Value & "', '" & FunctionalArea.Value & "', '" & Strategy.Value & "', '" & Approver.Value & "', '" & Owner.Value & "','" & ActionsTaken.Value & "', '" & DocumentumHyperlink.Value & "', '" & Comments.Value & "', #" & FirstDueDate.Value & "#, '" & Frequency.Value & "', =(Now))"
DoCmd.RunSQL strSQL
It now comes up with syntax error 3075 when I attempt to run it. I have been over the code again and again and cannot find issue with it. Is anyone able to help or offer advice?
Thanks in advance, Pete