If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Tax Exemption Case.
Hi, there, I am building an invoice form which needs tax exemption case. The first step I took was adding yes/no data type field to customer table. Then, I put an invisible textbox named taxcode which bring the yes/no field value when the invoice form loads by using onload command as follow: If Me.taxcode = 0 then Me.tax = 0 End If The tax field has control source. (=[total]*[taxrate];Currency Format) When a tax exemption customer loaded, the form gives a run time error, "You can't assign a value to this object". Could anyone tell me how to fix this problem? Moreover, is there any better way to distinguish tax/none tax pay customer otherthan what I have used above? Thank you. |
#2
|
|||
|
|||
Tax Exemption Case.
I would set the control source to:
=[total]*[taxrate] * Abs([YourYesNoFieldName]) -- Duane Hookom Microsoft Access MVP "Sohn" wrote: Hi, there, I am building an invoice form which needs tax exemption case. The first step I took was adding yes/no data type field to customer table. Then, I put an invisible textbox named taxcode which bring the yes/no field value when the invoice form loads by using onload command as follow: If Me.taxcode = 0 then Me.tax = 0 End If The tax field has control source. (=[total]*[taxrate];Currency Format) When a tax exemption customer loaded, the form gives a run time error, "You can't assign a value to this object". Could anyone tell me how to fix this problem? Moreover, is there any better way to distinguish tax/none tax pay customer otherthan what I have used above? Thank you. |
#3
|
|||
|
|||
Tax Exemption Case.
Dear Mr.Hookom, Thank you very much for your help, it works great. BTW, is there any better way to achieve the same result than using I have? Thank you "Duane Hookom" wrote: I would set the control source to: =[total]*[taxrate] * Abs([YourYesNoFieldName]) -- Duane Hookom Microsoft Access MVP "Sohn" wrote: Hi, there, I am building an invoice form which needs tax exemption case. The first step I took was adding yes/no data type field to customer table. Then, I put an invisible textbox named taxcode which bring the yes/no field value when the invoice form loads by using onload command as follow: If Me.taxcode = 0 then Me.tax = 0 End If The tax field has control source. (=[total]*[taxrate];Currency Format) When a tax exemption customer loaded, the form gives a run time error, "You can't assign a value to this object". Could anyone tell me how to fix this problem? Moreover, is there any better way to distinguish tax/none tax pay customer otherthan what I have used above? Thank you. |
#4
|
|||
|
|||
Tax Exemption Case.
I'm not sure what you are asking. Do you want a better method than I
suggested or are you asking why your solution didn't work as expected? -- Duane Hookom Microsoft Access MVP "Sohn" wrote: Dear Mr.Hookom, Thank you very much for your help, it works great. BTW, is there any better way to achieve the same result than using I have? Thank you "Duane Hookom" wrote: I would set the control source to: =[total]*[taxrate] * Abs([YourYesNoFieldName]) -- Duane Hookom Microsoft Access MVP "Sohn" wrote: Hi, there, I am building an invoice form which needs tax exemption case. The first step I took was adding yes/no data type field to customer table. Then, I put an invisible textbox named taxcode which bring the yes/no field value when the invoice form loads by using onload command as follow: If Me.taxcode = 0 then Me.tax = 0 End If The tax field has control source. (=[total]*[taxrate];Currency Format) When a tax exemption customer loaded, the form gives a run time error, "You can't assign a value to this object". Could anyone tell me how to fix this problem? Moreover, is there any better way to distinguish tax/none tax pay customer otherthan what I have used above? Thank you. |
#5
|
|||
|
|||
Tax Exemption Case.
Dear Mr.Hookom, A better method. Thank you. "Duane Hookom" wrote: I'm not sure what you are asking. Do you want a better method than I suggested or are you asking why your solution didn't work as expected? -- Duane Hookom Microsoft Access MVP "Sohn" wrote: Dear Mr.Hookom, Thank you very much for your help, it works great. BTW, is there any better way to achieve the same result than using I have? Thank you "Duane Hookom" wrote: I would set the control source to: =[total]*[taxrate] * Abs([YourYesNoFieldName]) -- Duane Hookom Microsoft Access MVP "Sohn" wrote: Hi, there, I am building an invoice form which needs tax exemption case. The first step I took was adding yes/no data type field to customer table. Then, I put an invisible textbox named taxcode which bring the yes/no field value when the invoice form loads by using onload command as follow: If Me.taxcode = 0 then Me.tax = 0 End If The tax field has control source. (=[total]*[taxrate];Currency Format) When a tax exemption customer loaded, the form gives a run time error, "You can't assign a value to this object". Could anyone tell me how to fix this problem? Moreover, is there any better way to distinguish tax/none tax pay customer otherthan what I have used above? Thank you. |
#6
|
|||
|
|||
Tax Exemption Case.
You stated "it works great" and it can't be a whole simpler since it doesn't
involve any code modules. There may be a better expression but I can't think of it. -- Duane Hookom Microsoft Access MVP "Sohn" wrote: Dear Mr.Hookom, A better method. Thank you. "Duane Hookom" wrote: I'm not sure what you are asking. Do you want a better method than I suggested or are you asking why your solution didn't work as expected? -- Duane Hookom Microsoft Access MVP "Sohn" wrote: Dear Mr.Hookom, Thank you very much for your help, it works great. BTW, is there any better way to achieve the same result than using I have? Thank you "Duane Hookom" wrote: I would set the control source to: =[total]*[taxrate] * Abs([YourYesNoFieldName]) -- Duane Hookom Microsoft Access MVP "Sohn" wrote: Hi, there, I am building an invoice form which needs tax exemption case. The first step I took was adding yes/no data type field to customer table. Then, I put an invisible textbox named taxcode which bring the yes/no field value when the invoice form loads by using onload command as follow: If Me.taxcode = 0 then Me.tax = 0 End If The tax field has control source. (=[total]*[taxrate];Currency Format) When a tax exemption customer loaded, the form gives a run time error, "You can't assign a value to this object". Could anyone tell me how to fix this problem? Moreover, is there any better way to distinguish tax/none tax pay customer otherthan what I have used above? Thank you. |
Thread Tools | |
Display Modes | |
|
|