Search results

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

sorry, im a bit confussed? why is there 25,35,75 ? Also the number of arrays will vary? Thanks k0r54

Hi, Is there a way i can create an array with no bound like so (FieldSep being the array) - Do pnt = InStr(stp, ary, " ") - 1 FieldSep(cnt) = Array(pnt, fmt) stp = pnt + 2 cnt = cnt + 1 Loop While InStr(stp, ary, " ") <> 0 Or stp > Len(ary) The problem i get...

Hi, Is there a way i can perfrom some functions before or after the next record in the recordset is loaded. (form is set to continuous) For instance: If i have 5 records in my forms record source after the 1st it will msgbox "sumin" after the second msgbox "sumin" and so on? This is the...

Hi, Like the "ontime" function in excel is there an equivilant function in access. The ontime function allows me to repeat a procedure within it every 10 min ( or watever i set it to) Thanks k0r54

Many thanks