geeky
01-09-2006, 01:14 AM
Dear Experts,
I really need your helps...I am creating an interactive invoice....
I really stack with this codes....I have a word document and
its form created with VBA words...in the form there are one combobox called "Item Code" and
five textfields called "Description", "Qty", "Unit Price" and "Total"....the scenario is, if I select "Item Code" it will show all data collected from access database and show into each textfields (except "Qty" textfield)
"Description" textfield and "Qty" (I let it blank for manual filling) (which is I already found it
about these codes and you should no worries about this) ...
My question is what codes: if I fill the Qty textfield i.e. with 2 (the number
integer).. and then when I click "update qty"..then it will deduct 2 as well in the "Item table" on Access file please???...
Furthermore, I provide an attachement of file for your review...
I would very happy if you provide me a walktrough/codes for this....
Thank you very much for your helps..
Sammy :hi:
I really need your helps...I am creating an interactive invoice....
I really stack with this codes....I have a word document and
its form created with VBA words...in the form there are one combobox called "Item Code" and
five textfields called "Description", "Qty", "Unit Price" and "Total"....the scenario is, if I select "Item Code" it will show all data collected from access database and show into each textfields (except "Qty" textfield)
"Description" textfield and "Qty" (I let it blank for manual filling) (which is I already found it
about these codes and you should no worries about this) ...
My question is what codes: if I fill the Qty textfield i.e. with 2 (the number
integer).. and then when I click "update qty"..then it will deduct 2 as well in the "Item table" on Access file please???...
Furthermore, I provide an attachement of file for your review...
I would very happy if you provide me a walktrough/codes for this....
Thank you very much for your helps..
Sammy :hi: