what is wrong with this statement?

R

ria

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
 
D

Douglas J. Steele

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