G Guest Aug 8, 2005 #1 I posted a question regarding this previously but can not see it in any discussions and I have had replies. Can anyone enlighten me??
I posted a question regarding this previously but can not see it in any discussions and I have had replies. Can anyone enlighten me??
A Arvin Meyer [MVP] Aug 8, 2005 #2 I think your quotes might be messed up. Try this one. Add a debug.print statement and see what shows up in the Immediate window, then copy and paste that into a query window. Once it's right the query should show the correct data. strSQL = "Insert into tblJobTimes(TimeStartJob, TimeStopJob)Values (#" & dteStartJob & "#", "#" & dteStartJob & "#");" Debug.Print strSQL
I think your quotes might be messed up. Try this one. Add a debug.print statement and see what shows up in the Immediate window, then copy and paste that into a query window. Once it's right the query should show the correct data. strSQL = "Insert into tblJobTimes(TimeStartJob, TimeStopJob)Values (#" & dteStartJob & "#", "#" & dteStartJob & "#");" Debug.Print strSQL
