Hello ::

I'm using UD 4 and Access 2000. I have a database column that is of Time format HH:MM:SS, and in order to insert this record from an insert record form, how should I go about it so that when the user inputs in the textfield,it inputs 05:45:00 in the DB. Right now it works if inputs are 5:45 OR 5.45, however inputs date like 01/05/1945 when inputs are 545 or 5,45 and error if it's 5 45. What is the best way to handle this?
pls help me!
regards,
Kiri

Are you wanting the user to actually enter the time? or do you just want the current time inserted in the record?

If its the latter then set the default value of the database field to <b>Time()</b> and this will automatically add the current time when a record is inserted.

Dave

Thanks Dave,
But I need the user to input the Time in the textfield of the form.
Any ideas?
Regards
Kiri

try lookin at the macromedia exchange for this

JavaScript Integration Kit for Macromedia Flash 5 Extension
its got loads of form validations, think theres one for time.

Dave

ASP/VBScript/IIS5.1/WinXPPro & WinXPHome

Edited by - Davecl on 29 Sep 2002 23:12:09