Recent content by kapil0712

IIf([A]>[B],IIf([A]>[C],[A]),IIf([B]>[C],IIf([B]>[A],[B]),IIf([C]>[B],IIf([C]>[A],[C])))) this will work Thanks kapil

Thank you Thanks kapil

Thank you Thank you... Where can i find the service pack for access 2007

Dear all, I am getting the configuring access 2007 setup everytime I am starting to use access 2007. Since I am using different versions of access on the same computer, the configuring window appears everytime I use different versions. Is there any way I can avoid that? Access other...

I have 15 different trainings and I need to find whether a particular training is been taken or not... If I am simply using the query with <> "Training name" Then it is still displaying the individual name since the other trainings that he has taken are not equal to "Training name" i.e. I want...

Thanks..finally got it to work with right path (form!subform!eventname) Bob, I didn't consider the path...i mean form name then sub form name then the event name. after considering it, it did work..:):):) thanks a lot... kapil

Re. attached is the form Bob attached is the complete list of tables. I am sorry there is no data in the tables since its against the institution policy. Hope that will get some idea.. thanks bob

attached is the form Thanks Bob, But I am still not getting the oncurrent event for the sub form. Attached alongwith is the example... Could you please check whats the problem...I have the problem posted earlier. Thanks a lot

reply: Combo box Thanks a lot again..but i am not able to find the the OnCurrent event.. I am able to find Onenter Onexit onclick and others.. What should I do? And the code is not working at the above mentioned places. Thanks

reply: Combo box Thanks Ken, I am sorry I am not very familiar with access. Could you please tell me where exactly to fit the code (Oncurrent event means?) Also where to find the name of the combo box? Thanks

Hello, I have set up a combo box which shows up the values of training types. If there is a training taken, then it has a specific date entered as well. I would like to disable the combo box (Training Type) when there is a entry in the field Date Taken so that no one can change the training...