Store a Listbox Items in Ms Access Db

[SandeepJagdeva]

Hi All
I am working on a project in which i have to face a problem. In my project I have Three listboxes and I want to store these listboxes Items in MS Access database. I don't know how to do this.
can any one help me

[hariharanmca]

Hi All
I am working on a project in which i have to face a problem. In my project I have Three listboxes and I want to store these listboxes Items in MS Access database. I don't know how to do this.
can any one help me

You can storethe items by running for or while loop with the list count
(Give bref detail about that)

[SandeepJagdeva]

Thanx for Reply

I give you some details:
My project is Making a VAT-Invoice. In this invoice there are Three fields with listbox e.g. 'Sr. No', 'Item Discription', and 'Quantity'. I use Three textbox to enter Values in listbox and a Command Button Name 'ADD'. When user fill all three textboxs and click on 'Add' Button all items add to listboxes. Its OK till now, But Now I have to Store all these three Listboxes items to MS database. I am confuse here, how to do this. And I am also confuse here that What type of field I have to choose in database to store these listbox Items.
Plz Help me. If u can. Send Example code if u can. Thanx.

[hariharanmca]

Thanx for Reply

I give you some details:
My project is Making a VAT-Invoice. In this invoice there are Three fields with listbox e.g. 'Sr. No', 'Item Discription', and 'Quantity'. I use Three textbox to enter Values in listbox and a Command Button Name 'ADD'. When user fill all three textboxs and click on 'Add' Button all items add to listboxes. Its OK till now, But Now I have to Store all these three Listboxes items to MS database. I am confuse here, how to do this. And I am also confuse here that What type of field I have to choose in database to store these listbox Items.
Plz Help me. If u can. Send Example code if u can. Thanx.

why don't you use ListView than listbox...?
you can save with single for or while loop in that list view

[hariharanmca]

Thanx for Reply

I give you some details:
My project is Making a VAT-Invoice. In this invoice there are Three fields with listbox e.g. 'Sr. No', 'Item Discription', and 'Quantity'. I use Three textbox to enter Values in listbox and a Command Button Name 'ADD'. When user fill all three textboxs and click on 'Add' Button all items add to listboxes. Its OK till now, But Now I have to Store all these three Listboxes items to MS database. I am confuse here, how to do this. And I am also confuse here that What type of field I have to choose in database to store these listbox Items.
Plz Help me. If u can. Send Example code if u can. Thanx.

Private Sub cmdAdd_Click()
lvItemList.ListItems.Add lvItemList.ListItems.Count + 1, , txtSerialNo
lvItemList.ListItems(i).SubItems(1) = txtDesc.Text
lvItemList.ListItems(i).SubItems(2) = txtqty.Text
End Sub


Private Sub cmdOk_Click()
For i = 1 To lvItemList.ListItems.Count
strSql = ""
strSql = "insert into tblTaxInvoiceDetail (Slno,Desc,Qty) values(" & Val(lvItemList.ListItems(i).Text) & ",'" & lvItemList.ListItems(i).SubItems(1) & "'," & Val(lvItemList.ListItems(i).SubItems(2)) & ")"
conn.Execute strSql
Next i
End Sub

[SandeepJagdeva]

Thanx for Codes
I will Try that and tell you my results

Have A Nice Day