VB Insert SQL with Time Format Field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

HELP :(

tblTime
TimeID (Key)
TimeSlot (Time)
Click to expand...

I have a VB Module to insert TimeSlots. As a test I did the following:
tmpTimeID = 2
tmpTimeSlot = 1010 (defind as Integer)

SQL Statement is:
SQL1="INSERT INTO tblTime (TimeID, TimeSlot) VALUES (' " & tmpTimeID & " ' ,
' " & tmpTimeSlot & " ' ) "

It creates the record with the key of 2, but for TimeSlot field is EMPTY!
I tried chaning the tmpTimeSlot to String (instead of Integer) and still
nothing....

Anyone? Help... Please....
 
Hi,
if you TimeSlot has date/time type - then you can insert correct value in
following format: #mm/dd/yyyy hh:hh#
 
Sorry for the tripple post... seemed like it did not post it so I tried
again...

Anyway, I found the solution in the meantime :)

(have to be string HH:SS) - so it is working....

Blessings to all...
 
Back
Top