Recent content by k0r54

I have tried a few things with no luck :( any ideas? Cheers k0r54

That is used in a form text box.

Working code: - =IIf(Int(([localtime]-[reported])*24)<1,Format(([localtime]-[reported]),"h:nn"),Int(([localtime]-[reported])*24) & ":" & Format(Int((([localtime]-[reported])*24)*60)-(Int(([localtime]-[reported])*24)*60),"00"))

AHHHHHH SOOO SIMPLE lol, havin a bad day of course. 60 * the number of hours (50) = 3000 3015 - 3000 50:15 Correct?

ok, i have been sitting here racking my brains lol no such luck - what am i missing

lol im looking but not seeing. it would be helpful to spell it ::confussed::

Oh ok, sorry. I just realised what you meant. Can that 48.5 be converted into 48:30 ? Thanks k0r54

Hi, Hi the problem i seem to have though is it only goes up to 24 hours then starts again so anything where the dates are over 24 hours it just starts at 0 again ? Thanks k0r54

Hi, Is there a way i can work out the number of hours and min between two dates n time. The dates n time will look like this: - 9/4/2006 17:47:00 PM - 11/4/2006 14:47:53 I just want it to tell me the number of hours and min between them. Thanks k0r54

Hi, Hi, I have a continuous sub-form and it has 3 fields date, problem and action. i am currently ordering it by date DESC. Want i am after if it is possible is too somehow splite so there is a gap or a line or something to patition if by months. There i will only every be 3 different months...

Hi, Im affraid that doesn't do it :(

Hi, Ok i am using the following code to hide the access window but when i do it, it also hides it from the taskbar aswell. Is there any modifications to the code that will hide the background window but also keep it on the taskbar. thanks k0r54 Module: - Option Compare Database Private...

All, Found out it is the form_current that does it. Thanks k0r54

Hi, How can i run some vba cose directly after i click the move next button on the navigation but at the bottom of the form. Thanks k0r54

Ahhh i have done it I done ReDim FieldSep(100) then after the loop done ReDim preserve FieldSep(cnt - 1) Thanks k0r54