HI,
I'm just a beginer in access few days. I need your help.
I have to do 1 application with 5 listbox(named "l1"..to "l5") on the form "Fcom" , 5 inputs box( named "q1"..to "q5" for quantity of the items selected in the listbox), 5 button OK (named "bok1"..to "bok5" for calculating the money( price unit of items selected * quantity) and display the result in a input box named "total" each time the button "ok" is used. After that , with the button " save" , it add the data from all the listbox(nameItems), the quantity in all the input box to a table named " Tcom".
In this table it had 10 fields name "article1"..to "article10", 10 fields named " quantity 1" to "quantity 10", 1 field for "total"
I think it should used a boucle for that but I have no idea about it.
Then the application only work fo saving 10 enregistrements for 1 time, at the 11st times, a message will display " max 10 enregistrements " then all the input box, button "ok" must be dissapeared by using a function Visible = False
..Would you have any ideas about it?Please help. Many thanks.
Ytros
I'm just a beginer in access few days. I need your help.
I have to do 1 application with 5 listbox(named "l1"..to "l5") on the form "Fcom" , 5 inputs box( named "q1"..to "q5" for quantity of the items selected in the listbox), 5 button OK (named "bok1"..to "bok5" for calculating the money( price unit of items selected * quantity) and display the result in a input box named "total" each time the button "ok" is used. After that , with the button " save" , it add the data from all the listbox(nameItems), the quantity in all the input box to a table named " Tcom".
In this table it had 10 fields name "article1"..to "article10", 10 fields named " quantity 1" to "quantity 10", 1 field for "total"
I think it should used a boucle for that but I have no idea about it.
Then the application only work fo saving 10 enregistrements for 1 time, at the 11st times, a message will display " max 10 enregistrements " then all the input box, button "ok" must be dissapeared by using a function Visible = False
..Would you have any ideas about it?Please help. Many thanks.
Ytros