var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Update Statement
I have been staring at this line of code for hours and cannot figure out what is wrong with it. Anyone see anything I am missing?
CurrentDb.Execute "UPDATE tblPunches SET tblPunches.end_datetime = Now(), tblPunches.misctime = " & Me.misctime & ", tblPunches.vacatime = " & Me.vacatime & ", tblPunches.unpaidtime = " & Me.unpaidtime & ", tblPunches.othertime =" & Me.othertime & ", tblPunches.otherexp = '" & Me.otherexp & "' WHERE ((tblPunches.end_datetime) Is Null) AND ((tblPunches.emp_id)= " & Me.emp_id & ");"
I am not good with SQL so I built an UPDATE query and then copied and pasted the statement into Access 2000 form. I keep getting syntax errors, yet when I run the query it works...any ideas?