time convertion problem

[biskra]

my prolem is about the texbox work time where i call the Function basMinsToHrMnSec to convert result to day:hour:Minutes
any help please.

 

[RichO]

Users of Access 2000 and previous won't be able to help because your sample is in the format of a newer version. If you don't get any help you may want to attach a DB converted to a previous version.

 

[biskra]

ok with Access 2000

 

[RichO]

To begin with, there is an issue with your form that it will not accept any [Event Procedure] in the On Current event. I did not dig into it but rather created a brand new form which ended up working.

The proper way to call your function is:

Me.txt8 = basMinsToHrMnSec(DateDiff("n", RequestTime, ResponseTime))

However, this same calculation can be done without a function, like this:

Me.txt8 = Format$(CDate(ResponseTime) - CDate(RequestTime), "hh:nn:ss")

Hope that works for you.

 

[biskra]

thanx for your help RichO, i learn how to call a function.