what is wrong with this statement?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a module to insert values into tbl1 - ddate = date and part
should be 10.

CurrentProject.Connection.Execute "INSERT INTO tbl1 (ddate), (part) VALUES
(#" & Format$(dtmLoop, "mm/dd/yyyy") & "#,10)"

Access tells me the syntax is wrong.

Thanks
 
CurrentProject.Connection.Execute "INSERT INTO tbl1 (ddate, part) VALUES
(#" & Format$(dtmLoop, "mm/dd/yyyy") & "#,10)"
 
Back
Top