VB Insert SQL Time format field Value

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

Guest

Hello,

I have a module to insert a record to tblTime (TimeID Key, TimeSlot Time)

The SQL statement in the VB Module is:
"INSERT INTO tblTime (TimeID, TimeSlot) values (tmpTimeID,LoopTime)"

tmpTimeID is calculated in the program as 2 (for test reason)
LoopTime is an Integer field and is calculated as 1010 (again for test
reasons)

The record is being inserted with the key of 2, but in the TimeSlot field,
there is no value... it is empty.
I tried changing the LoopTime to a String (instead of Integer) and it still
did not work....

Help Please... I am losing it :(
 
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 using Time Field 1
VB Insert SQL with Time Format Field 2
Help! Why doesn't this work after 2 times? 9
Datatype Mismatch using integer 2
Table lookup value on a form - text or interger field? 5
Need Help with SQL statement - "Insert Into" 7
Insert Into -- expected end of statement error 7
Inserting value of an unbound Textbox 2

Back
Top