Search results

The row source type - table/query row source customer_credit_good_bad_tables

Basically I am using a text box to chose a selection of credit scores so if they have an excellent credit the score should be 50. however when I select the box for say excellent score nothing calculates or show any number based on the calculation above. I hope this helps. I am truly a beginner.

I do appreciate the response but I am a novice at Access and need quite a bit more hand holding. I would appreciate any help possible. I understand the problem I just don't know how to do it the correct way or how to fix what i already did.

This is what i am trying to do... What is rong with code ????? If [Forms]![Customer Form]![cust_credit_reply_1] = " [Bad Credit]"Then [Forms]![Customer Form]![cust_credit_score_1] = 5 ElseIf [Form]![Customer Form]![cust_credit_reply_1] = "[PoorCredit]"Then [Forms]![Customer...

question regarding problem Now that I understand the issues how would I go about correcting it? What options or function should I use to correct? If possible send me menu selection and options. Thanks

question regarding problem No that I understand the issues how would I go about correcting it? What options or function should I use to correct? If possible send me menu selection and options. Thanks

Hi, RuralGuy, thank you for your help but i do not understain what you mean by control in the Afterupdate event of the same control. Johnny C

Can some one help me with this code, I get no return, ??? . Private Sub cust_credit_score_1_AfterUpdate() If [Forms]![Customer Form]![cust_credit_reply_1] = " [Bad Credit]"Then [Forms]![Customer Form]![cust_credit_score_1] = 5 ElseIf [Form]![Customer Form]![cust_credit_reply_1] =...

Hi RuralGuy Sorry about this, but i do not understain, control in *never* equal & leading space can youexplain this to me. Thank You. John

Thank You RuralGuy I test you code and all i get is the number 15 can not get a return of 5 or 10. I Thank you for your help...

Hi, can someone help me with this code I do not get a return ( 5 ) or ( 10 ) ( 15 ). Anyone have a solution,any help would be appreciated. Private Sub cust_credit_score_1_AfterUpdate() If [Forms]![test credit]![cust_credit_reply_1] = " [Bad Credit]" Then [Forms]![test...

Still Not Working. Hi Matt, I did just like you said to the letter, and when i ext the code, and ext the form, i go back & open the form up to test the code, Nothing no response. I go back to check the code and it looks ok. See for your self. Private Sub cust_credit_score_1_AfterUpdate() If...

Not Working ? Thank you for your help, but where do I put this code at, in control source, default value, validation rule. Also I understain [form name] this would be the name of my form, but I do not understain [forms] ??? I put the code in properties / control source, save the code, then go...

Hi, can someone help me with this formula. i have one field called notice_1 this field is a combo boxs multiple choice ( YES - NO ) Then i have 1 field called score_1 ( if notice_1 = "YES" then let score_1 = 5 else then let score_1 = 10 ) Does this make sense , I am an...

Can Somone help me Page Break : I have created a form in accress 2002, with two pages, and I place the page break between the two pages , and all I got was ¾ of the second page. I place the page break in other areas on top & on bottom as will in between the pages & I get the same results all the...

Questions / Help : What I would like to know about Microsoft SQL Server & Access 2003 : I am a novice at creating my own database. I would like to use Microsoft SQL Server & Access 2003 . I have in the last 3 months read all I can about creating a database in Microsoft Access 2003 . Now I...