Search results for query: *

I have a comboBox that as row source of this: SELECT DISTINCT tblPerson.Member FROM tblPerson; names like davis, smith, jones will fill the form in with information about which name I pick. But a name like O'Dowd, does not fill the form in. The form stays blank. Thanks for any help in...

Thank you for taken the time to help me. This form is to deal with co-workers medical bills. They have a $300.00 ded they need to met of a year per. So say that they have met $275.00 of their ded for the year. Then hand in a bill for $100.00, $25.00 would go to the $300.00(yearly ded) & they...

Ok, I got it to work in my form thank you, but can you give me some more help. So far I have in the Code three select case 3, 7 & else. What if I need to had a case 4 that would be $30. Plus case 7 that is $50.00 it puts $50.00 which is only true if they met thier full ded...

Does it matter that ExpenseCatID is a Combo Box

I'm sorry that I'm having a hard time understanding this, it problem is very simple. I can verify the function in the immediate window there I can see that it works. On my form I have billAmount ExpenseCategoryID ded I add a unbound text box and in the control source I put...

Majp, I'm still tried to figure out how to use the public function you told me about. I have a query using my tblBill. I have billamount, ded, & expensecatID field on the query. The I put the public function (getbillamount in a blank field. When I try running the query I get a error code...

I'm good TheACEMAN1, how about you. Your code worked but the [billamount]-nz[ded],o also has to be apart of the [expensecategoryID]=7. Becasue if there was a ded the person would not get the $50.00. MAJP, I now have a module name getBillamount and on my form I have bound text boxes bill...

Jamaarnee I tried your code but I receive a error (the expression you entered contains invalid syntax. Also the ([billAmount]-nz([Ded],0) apply for whole if statement and with you code it looks like it does not. Majp, I would like to use the custom function and it looks like it would work...

I have a iif function that does work. But I would like it to do more. Here is my iff function =([billAmount]-nz([ded],0))*IIf([ExpenseCategoryID]=3,0.5,IIf([ExpenseCategoryID]=7,"50.00",0.8)) This is the part not working right ([ExpenseCategoryID]=7,"50.00", I know why becasue I would like...

I have this code on a form, the me![percent] has a iff statment which is: =([expenseItemAmount]-nz([ded],0))*IIf([ExpenseCategoryID]=3,0.5,0.8) then I have this code on the form: Private Sub Form_BeforeUpdate(Cancel As Integer) Me![ckamount] = Me![Percent] Me![OONAmount] = IIf([OON] = -1...

PH, This works great for one of my text boxes. But I have a second text box that has a if statment it it. Which is: =IIf([oon]=-1,[ckamount],0) How do I change this code: Me![CkAmount] = Me!Percent To handle the if statment Thank you, Irene

PH, I figure what was wrong, I need to do a new record to see it work. Thank you for you help

PH, This is what I think your telling me and it's not working Private Sub Form_BeforeUpdate(Cancel As Integer) Me![CkAmount] = Me!Percent End Sub What am I doing wrong Irene

This thread seems like something I could use but I don't understand where to put the code. Does it go on the beforeupdate on the form or the beforeupdate on the text box [CkAmount] I believe this is the right code: Me![CkAmount] = Me!Percent my table is tblbill my form is frmbill on the form...

I would like to save the value of a text field on the access form into a table. Can you tell me how to do this? I would believe it is some code.

Sorry about that say the iff statement result is $50.00, is there away that 50.00 is filled in a table field name [ded]

PH Thank you that works much better. Can you tell me if there is a way to get the result to fill in a cell on a table Irene

Can someone help me with my iff statement =IIf([ExpenseCategoryID]=3,([ExpenseItemAmount]-[ded])*0.5,([ExpenseItemAmount]-[ded])*0.8) My problem is when [ded] is blank. Thanks for any help in advance