I keep getting a syntax error on the last line of this Insert statement. I have tried a number of things and nothing is working. Please help me. I am working in Access and trying to enter this data into a table in the database. Do I need to open the table or define the database or something?
DoCmd.RunSQL "INSERT INTO Trans Log " _
& "(USER, TIME, TRANS) VALUES " _
& "('1', '1', '1');"
DoCmd.RunSQL "INSERT INTO Trans Log " _
& "(USER, TIME, TRANS) VALUES " _
& "('1', '1', '1');"