Dim strSQL Syntax Issue

[burrina]

I'm missing something here but don't know what.
The Data Types match and they are in order. I get a syntax error.

      strSQL = "INSERT INTO tblHour (Hours, WorkDate, SickDay, SickDte) VALUES (" _
   Me.AbsenceHrsID & ",#" & Format(Me.AbsenceDteTo, "yyyy-mm-dd") & "#,True,#" _
   Format(Me.AbsenceDteTo, "yyyy-mm-dd") & "#)"
CurrentDb.Execute strSQL, dbFailOnError

 

[Solo712]

I'm missing something here but don't know what.
The Data Types match and they are in order. I get a syntax error.

      strSQL = "INSERT INTO tblHour (Hours, WorkDate, SickDay, SickDte) VALUES (" _
   Me.AbsenceHrsID & ",#" & Format(Me.AbsenceDteTo, "yyyy-mm-dd") & "#,True,#" _
   Format(Me.AbsenceDteTo, "yyyy-mm-dd") & "#)"
CurrentDb.Execute strSQL, dbFailOnError

The date format expected by an SQL statement is "mm/dd/yyyy"

Best,
Jiri

 

[spikepl]

The standard way for beginners for decoding VBA making up SQL is this:

http://www.baldyweb.com/ImmediateWindow.htm

Read it carefully and follow the entire recipe.

 

[gemma-the-husky]

it might be the sick day bit, with a text of true

I would either do this

"# , " & -1 & " , #"

or this

"# , " & True & " , #"

 

[burrina]

Thanks, not so good at SQL.