VB Insert SQL using Time Field

G

Guest

Hello,

I have a module that inserts records to a tblTime

tblTime
=====
TimeID (AutoNum)
TimeSlot (Time)

In my module I calculate the TimeID and LoopTime (Integer)

TimeID = 2
LoopTime = 1030

The SQL is: "Insert into tblTime (TimeID, TimeSlot) values (LastTimeID,
LoopTime)"

It inserts the record fine (key of 2) but the Time field is EMPTY.

I have tried changing the LoopTime to a String Type, but it still did not work

Please help..
 
G

Guest

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VB Insert SQL Time format field Value 1
VB Insert SQL with Time Format Field 2
Datatype Mismatch using integer 2
Help! Why doesn't this work after 2 times? 9
help editing data 2
Record insert/delete anomaly 0
Insert into syntax error 2
Need Help with SQL statement - "Insert Into" 7

Top