Display real time Now() etc.

[Rich_Lovina]

Detailed search cannot answer my time problem. Returning after long break in programming, I am trying to create a form to display TimeIn and TimeOut fields such that actioning an OnClick command (or separate tick-box), TimeIn field will hold current time for that record. Need to set the same for a TimeOut field. Both cases time always to be < 24 hours.

Am so rusty on MS Access putting default value as =now() produces an error!!
Any basic help to wind up the old mind always appreciated.

 

[ShaneMan]

Detailed search cannot answer my time problem. Returning after long break in programming, I am trying to create a form to display TimeIn and TimeOut fields such that actioning an OnClick command (or separate tick-box), TimeIn field will hold current time for that record. Need to set the same for a TimeOut field. Both cases time always to be < 24 hours.

Am so rusty on MS Access putting default value as =now() produces an error!!
Any basic help to wind up the old mind always appreciated.

Hey Rich,

Have you tried '=Time()' If I remember right Now() gives you date and time so maybe that's whats causing your headaches.

HTH,
Shane

 

[Rich_Lovina]

Thanks for tip. Will try time. p.s. Have solved format error, was formatting in form before dbase design.