Search results

Hi I have a main form for data entry.. on lost focus a popup form (Modal) opens then I need to enter some data. after that is a button to close the popup form.. then... I want my main form to set a new record.. but it was adding the data that was retained when I opened my popup form.. so I tried...

Thank You! I really appreciate it.. Thanks for the big help..

Thanks anyway.. I really can't figured how it works and in which even should I put that code.. Thanks again.

Hi.. thanks for the reply... can you check this discussion. http://www.access-programmers.co.uk/forums/showthread.php?t=164321 (especially the attached picture) This effects is what I really wanted..but I dont know how to do this.. thanks...

Hi Im a newbie to access so please forgive me for my question.. Is there a way to change the color of mainform into a Light Black color upon opening of my popup form? (and return to its nomal color when I closed the popup form) I just think it looks nice to have this effects.. I read about...

THANK YOU SO MUCH!! I really appreciate your help.... Thanks again..

Thanks for the reply.. but Im having a "Loop without Do" error... sorry im a newbie to access and VBA...Thanks again..

Hi, I want my button to fire/Run the command below based on the number in my unbound textbox field (txtboxnumber) the scenario will be... to input the number in my txtbox ex. "5" ....then when I click on the button (ComButton) it will run the code below 5 times... Private Sub...

Thanks for your reply. Yes you are right, I can have same results using subform. but the reason I am trying to do it based on my format is to save time in encoding all those details again. It is actually a monthly basis (30 days data) Im just showing 5 rows in my sample. Most of the Details in...

Hi, I need a code for my Forms.. I dont know if this is possible.. Im a newbie in access please help.. I have a form (PayrollForm) with multiple sets of fields...what I want to do is.. after entering all the data in the first set of record.. it shoul be save to my table (PayrollTable)... then...

Im attaching my sample database... thanks.

Thank you for your reply.. but still not working...I really dont know whats wrong with my forms...

Hi I have a mainform with 2 forms (form1 & Form2)I inserted using a drag & drop on design. after entering some data in my main form, it will go to my "form1".. and that is no problem at all... but after entering data into my "form1" I want the tab or the focus to be set in my "form2"... please...

I think it can be done by IIF function. but I dont know how to write IFF using multiple fields.... example.. If(Field1=A,1,0)+ If(Field2=A,1,0)+ If(Field3=A,1,0)+ If(Field4=A,1,0)+ If(Field5=A,1,0)... I know it is not the right way of adding those 5 Fields.. Any Idea?? Thanks for the reply...

I think it can be done by IIF function. but I dont know how to write IFF using multiple fields.... example.. If(Field1=A,1,0)+ If(Field2=A,1,0)+ If(Field3=A,1,0)+ If(Field4=A,1,0)+ If(Field5=A,1,0)... I know it is not the right way of adding those 5 Fields.. Any Idea?? Thank for the reply...

Hi Bob.. I have another question. How to write the formula in Query "TotalField". here is the scenario... I want to count the number of "A" in Field1,Field2,Field3 & Field4 in Query.. Field1====Field2====Field3====Field4==TotalField =A======____======A======____=====2

Thank you so much... I will surely try the code... and yes.. I already change my table structure. I really appreciate your Help.. Thanks..

I was trying to get it from a form.. this is what's on my mind.. If fields NY1, NY2, NY3, NY4 & NY5 is Equal to "N or (N for "NO" or false)" then sum fields Q1,Q2,Q3,Q4 & Q5 or should i say corresponding Q Fields.. I know it's been complicated I was getting confused also.. I think I need to...

How to write this in Expression builder? I want to add fields with "false (N)" value only. In my example below the total should be 12 only (adding 3+2+3+4=12).. Take Note that Y/N fields are constantly changing... Using IIF formula might be the answer but Im a newbie in access.. please help...

I have this form with SubForm that i used to enter data .. I want to copy or retain all data or entries in my "Days" & "Month/Year" fields after saving, thus leaving my "Employee ID" & "Hrs. Worked" Field Blanks.. see sample below.. Thanks in advance for any help.. (The number of rows may...