Recent content by MikiA

Ok, i will try on that way. Thank to you and all guys who was help me.

You, like new employee have 20 days. If you don’t spend those days, they become "old" days. At the beginning of each year you get 20 new days You have to spend the "old" days until the sixth month of the following year or you lose the right to them. The days of the "old" vacation are spent...

But, you push me to think... Can i all values put at same col ? Then will be easy to calculate old and new days. Cos new days value is always 20. And spended days have value 1. Right ?

Thats all i want. To track spended days. But cos have many employee, hand tracking its to complicate

When all field in col A down to zero, will start substract from col B. 20 -1 = 19 But for ID 1 for example can be substract several time 20 - 1 - 1 - 1 for ID 2 = 20 - 1 for ID 3 = 20 -1 -1 end col B will go to zero.... For each name (or ID), C values will be assigned individually in the...

Yes. Exactly. When value in C down to zero, start subtraction from B

Actually i dont have a sample. That was a start. And i stuck. At first it seemed simple to me.... I was think its just A-C and B-C.... but i wrong. Now I am looking for get value from the previous record as you suggested to me. But table should be somethong like this B will be always 20 at start

I just google about that and i am not sure that i understand very well

Yes. Will be always zero

Value C is constant value and always have value 1 So, A-1 until zero, then when A = 0 starts B-1

Hello, i wanna try to create query where I want to subtract the value of C from the two fields, A and B. Basically A-C and B-C. But that the subtraction from the column A goes to result 0. When the final result is zero the subtraction from B the column begins. I was try until now to use...

I understand. I will try with Conditional Formatting. Honestly, will be much for work, but result will be better i belive. Thanks for you time :)

I have always viewed conditional formatting as a temporary solution

Hello, I have a form and a lot of text boxes on it. I want to change the color of the text box when the value is entered. So, i know how to do that using conditional formating. Also, i know how to that using after update event..... My question is: Is it posible create a loop and check all text...

I understand. One more question. Is it posible, when i set data entry to no, and when i open the form to get column A populated and rest field empty ?