Search results

Thanks again.. Only one can be ticked...

Thanks for your help. The user enters the date and also i have 3 tick boxes. Tick boxes are VL,SL,PH. those that tick box is in VL field, then the back color of the date should be RED otherwise remains BLACK. Hope that this helps you

Thanks for your help.. It is a continuous form. There are approx. around 50 dates.

Hi.. I have a field date and i need that on particular dates for example on the 01/01/2011,05/01/2011 etc etc the back color will become red for example. The date is already entered in the database. thanks for you help.

Thanks for your help but where i can put the command please..which field and after before?? thanks again

Hi. I created a small database which I have as fields date of entry , req no, etc etc. When i enter the date of entry, the req no must be shown automatically commenced with number 1,2,3 etc etc I need some help that when its 1st january of every year, the reqno must begin again from 1 and...

Managed to get it worked!!! Thanks a lot.

I cannot make the total it in the same crosstab query?? I you look test2.jpg, on the right hand side there are 1,5,etc under each other, i want the totals there.

Thats right...

Hi.. The total of every Month is placed on the right as Row Heading. The 1-31 are column headings and static. Hope this helps you.

Thanks again for your help.. Another question please, now i want to add all those A which are equivilant to 1 and B are equivalent to 1/2. I think is a bit complicated but for sure you will help me. If for example i have in January 4A's and 1B, the total should be 4.5 Thanks again....

Thanks a lot. It works perfectly..

Thanks for your help but looks what happened, all the chart is filled... I need only specific dates.

I have this card.. its attached in the image, how can i get those that are - 1 has to be shown as A and 0 has to be shown as B. thanks a lot Any help please..

I am trying to do the same but its not working for me. Can you please help thanks. Where can i put the code please?

Thanks a lo....

Finally it is solved using format date. Format(Me![Date Taken Leave], "mm\/dd\/yyyy") Thanks for everyone that helps me.

I have tried it also, no corruption I have noticed that from 02/01/2010 to 12/01/2010 accepts duplicate and from 13/01/2010 - 31-01-2010, duplicates are picked. Also noticed if you make a reverse order from 02-01-2010 till 12/01/2010 they are picked as duplicate even they are not in the...

Yes of Course.. i don't know why its not working, something strange.

BeforeUpdate event of the FORM ..