Recent content by the_black_code

Yea... This has been left unanswered for a good 5 years. Such a hard question :banghead:

Hi mrashid, Please find the attached file is the CHM developer guide for FlexArray control. Please note that FlexArray is no longer belong to Microsoft, as it's for VideoSoft. Thanks.

Hi, I solved the problem :cool: . Here is the solution: Public Function TimeDiffCal(ByVal StartingTime As Date, ByVal FinishingTime As Date) As Date Dim Hours As Integer, Minutes As Integer, Seconds As Integer, TotalSeconds As Integer TotalSeconds = DateDiff("s", InTime, OutTime...

Hi GalaxiomAtHome, I know all of that, but (in code) can you solve this? Thanks. A

Hi GalaxiomAtHome, No, again it gives a wrong answer. Look what it gives when I tried it: ?TimeDiffCal1("11:45:00","17:00:00") 11:45:00

Could you please tell me how to do the arithmetical subtraction? Thanks. A

Hi GalaxiomAtHome, Many thanks for helping me with this, but I want it to be as a time calcuation function to be used in other place in the code. Do you have a working replacement to the above function? Thanks and I realy appreciating your help. A

Hi GalaxiomAtHome, Is it OK to use CDate([fieldname]) Thanks. A

It returns: ?DateDiff("n", #08/04/2011 11:45:00#, #08/04/2011 17:00:00#) 315

You can replace with this: If IsNull(Me.TXT_Test.Value) OR IsEmpty(Me.TXT_Test.Value) Then A

Hi GalaxiomAtHome, Thanks for your reply, here is the code directley from the Immediate window in the Access VB Edittor: ?DateDiff("h","08/04/2011 11:45:00","08/04/2011 17:00:00") 6 ?DateDiff("n","08/04/2011 11:45:00","08/04/2011 17:00:00") 315 ?DateDiff("s","08/04/2011...

Hi GalaxiomAtHome, Thanks for your reply, but I did try the DateDiff function, and it gives a wrong values... for example: for (IN: 11:45:00) and (OUT: 17:00:00) example: Hours = DateDiff("h","11:45:00","17:00:00") 'YES, It returns 6 Minutes = DateDiff("n","11:45:00","17:00:00") 'It returns...

Dear All, I am currentley working on a function that can calculate the deferance between two gevin times and return the result :D. My code is as follow: Public Function TimeDiffCal(ByVal StartingTime As Date, ByVal FinishingTime As Date) As Date Dim BTime As Variant, ETime As Variant...

Hi prodigy, Sorry for my late reply, coz I just joined to the forum recentley. Using of MS FlexArray control or VideoSoft FlexArray Control in Access VBA is the same when you use it in the normal MS VB6. So, if you know how to use it in VB6, you can use it in Access VBA. Don't wary about...