Recent content by zozew

I understand your point, but the 3675 is actually not days between dates but rather accumulated "extra days" according to a few functions between two dates. The two dates are used for elapsed time just as you suggest, but the accumulated extra days are not anchored to any real date. So.. To...

thanks but i think this is a "little" overkill :) I'm going with this.. A1 = 3775 Year =INT(A1/365) = 10 Month = =INT(MOD(A1,365)/30) = 4 Days =MOD(MOD(A1,365),30) = 5 test: 10*365+4*30+5 = 3775

.....help.... 3675 days / 30.416 = 120.8246 months that's 10 full years and 0 months and 0.8246 days then to get the 0.8246 x 30.416 is 25.08 rounded down to 25 days my brain is starting to melt slightly...how do I get the months and then all into a formula....?

now im trying to get the years months and days separated..hmmm any suggestion how to do that.. years is pretty simple I can round that to whole numbers but months/days is trickier...

plog my mistake, I just want to print out the number I have in days displayed as years months and days with no connection to real date. below I tried something... My simple solution or kinda solution... I have to divide 365 with 12, use the 30.416 result, and then the remaining number...

Hi Plog, Well i actually dont care about 1910. An the solution I used found in several places... I just have a number of days that I want to be covered into y, m and d...so I guess ill have to divide 365 with 12, use the 30.41 result, and then the remaining number convert that into days...

Hi Everybody, I have this great little sheet doing some calculations with VBA and excel formulas. All is well until I decided to convert the resulting days into yers months and days.. =DATEDIF(0,3675,"y") & " years, " & DATEDIF(0,3675,"ym")&" months, " & DATEDIF(0,3675,"md")&" days" And the...

****************

I actually did just that, made a function and the only thing the afterupdate of the combo does was calling that function. But because I was using a value in a hidden column of the combo to set the right selected item. I needed the combo box's event to trigger and update it self and so on... Hope...

For my own sanity can you explain the syntax for calling the combos afterUpdate event.. i tested so many combinations and im pretty sure i tested the one that is working in your example and i got something like method or object not bla bla... thx Again

im not sure this is appropriate....but....i love you :D !!!!! works like a charm now!

Im getting promped "cant find project or library" when i click the add button in the popup, im using access 2010...and the date field in the popup comes up with #name?

attaching a simplified DB just the two forms... first form opens, click add new request, enter a name, click add, the popup is closed and the new request is in the combobox. i would like it to be selected after the small popup closes, and that the afterUpdate event is triggered just as if you...

i tested, and i could make public functions in the form an call it from another form but making the combos sub public gave me an error runtome error 2465 Application-defined or object-defined errorstill testing

I want to trigger the combo_afterUpdate event from a small popup form. Basically im adding a name in the popup that later goes in the combobox as an item. So when i click an add button in the popup it adds an item in the combo(adds to the table the combos record source) and selects it and fires...