I
iccsi
I have following code to update my table only time value from
datetimepicker
strSQLString = " UPDATE mytable " & _
" ShiftStart = #" &
FormatDateTime(dtpShiftStartTime.Value - Int(dtpShiftStartTime.Value),
vbShortTime) & "#," & _
" WHERE " & _
" ReasonID = " & MyPK
The backend is SQL server 2000 datetime field.
The result always inlcude date and time.
I use debug.print and get SQL running the SQL from query and it works
from query that the table only store time value.
it works in the code when I insert a new record. I use same code but
using insert into then the table get time value only.
For some reason, it always inlcude date value and time value in my
table when I use VBA code to update the SQL server table.
Your information and help is great appreciated,
iccsi
datetimepicker
strSQLString = " UPDATE mytable " & _
" ShiftStart = #" &
FormatDateTime(dtpShiftStartTime.Value - Int(dtpShiftStartTime.Value),
vbShortTime) & "#," & _
" WHERE " & _
" ReasonID = " & MyPK
The backend is SQL server 2000 datetime field.
The result always inlcude date and time.
I use debug.print and get SQL running the SQL from query and it works
from query that the table only store time value.
it works in the code when I insert a new record. I use same code but
using insert into then the table get time value only.
For some reason, it always inlcude date value and time value in my
table when I use VBA code to update the SQL server table.
Your information and help is great appreciated,
iccsi