Timer event - on an application form 1

[leckie]

I have an application form that applicants fill out when they come for interview, what I would like is a timer event so that when the applicant starts to fill out the form the timer starts, when he presses a "finished button" a hidden control would store the time taken to complete the form.

any help much appreciated . .

Gez

 

[KenReay]

Hi

No need for a timer here, at point you decide is the start (eg say on Form Open) set a variable (varStart say) = Now()

at point you deem to be the end,

Time taken = DateDiff("s",varStart,Now())

Note you need to DIM varStart with suitable scope to be available at the end point Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK

 

[leckie]

that has done the trick . . is it possible to show lapsed time in minutes and seconds or do I need to calculate that after ?

Gez

 

[KenReay]

Hi

Time is not my strong point, but you could try Format(MyResult,"hh:mm:ss&quot

No promises Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK

 

[leckie]

Tried it but did'nt succeed, i think a calculation is required to devide the result by 60 and have it displayed as a decimal . . . unless there is another way ?

thanks for the help anyway

regards
Gez