Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Deleting in database from list box
Bob gave me the following code last night and it works but i also need it to
look at the database and delete the entire row not just in the list box. Thank you in advance. To delete the selected item, just use lstData.RemoveItem (lstData.ListIndex) -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Jennifer" wrote in message ... Well it's been awhile. This stuff can just take over your life that when i lay off for a bit it ends up being a long spell. Well this should be easy. I have a userform with a list box containing 8 columns when i click on a row in the list box it fills the labels. I would like the option of deleting the entire row they see fit. I attached my update button just to give you an idea of what is going on. Thank you. Jennifer Private Sub btnUpdate_Click() Dim pointer As String pointer = lstData.ListIndex If pointer = -1 Then Exit Sub For index = 2 To source.Rows.Count If source.Cells(index, 1) = txtDataID.Text Then With source .Cells(index, eBoxes.Vendor) = txtVendor.Text .Cells(index, eBoxes.MiscCosts) = txtMiscCosts.Text .Cells(index, eBoxes.ProduceID) = Trim(txtProduceID.Text) .Cells(index, eBoxes.PalletNum) = txtPallet.Text .Cells(index, eBoxes.QtyPurchased) = txtQty.Text .Cells(index, eBoxes.QtySold) = txtSold.Text .Cells(index, eBoxes.Price) = txtPrice.Text .Cells(index, eBoxes.Frt) = txtFrt.Text End With Exit For End If Next LoadData lstData.ListIndex = pointer End Sub -- Though daily learning, I LOVE EXCEL! Jennifer Did this post answer -- Though daily learning, I LOVE EXCEL! Jennifer |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Deleting in database from list box
I responded in the original thread.
-- HTH RP (remove nothere from the email address if mailing direct) "Jennifer" wrote in message ... Bob gave me the following code last night and it works but i also need it to look at the database and delete the entire row not just in the list box. Thank you in advance. To delete the selected item, just use lstData.RemoveItem (lstData.ListIndex) -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Jennifer" wrote in message ... Well it's been awhile. This stuff can just take over your life that when i lay off for a bit it ends up being a long spell. Well this should be easy. I have a userform with a list box containing 8 columns when i click on a row in the list box it fills the labels. I would like the option of deleting the entire row they see fit. I attached my update button just to give you an idea of what is going on. Thank you. Jennifer Private Sub btnUpdate_Click() Dim pointer As String pointer = lstData.ListIndex If pointer = -1 Then Exit Sub For index = 2 To source.Rows.Count If source.Cells(index, 1) = txtDataID.Text Then With source .Cells(index, eBoxes.Vendor) = txtVendor.Text .Cells(index, eBoxes.MiscCosts) = txtMiscCosts.Text .Cells(index, eBoxes.ProduceID) = Trim(txtProduceID.Text) .Cells(index, eBoxes.PalletNum) = txtPallet.Text .Cells(index, eBoxes.QtyPurchased) = txtQty.Text .Cells(index, eBoxes.QtySold) = txtSold.Text .Cells(index, eBoxes.Price) = txtPrice.Text .Cells(index, eBoxes.Frt) = txtFrt.Text End With Exit For End If Next LoadData lstData.ListIndex = pointer End Sub -- Though daily learning, I LOVE EXCEL! Jennifer Did this post answer -- Though daily learning, I LOVE EXCEL! Jennifer |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
getting a list from a database | Excel Discussion (Misc queries) | |||
Automatically Deleting a List from Another (Larger) List | Excel Discussion (Misc queries) | |||
Deleting in a list box | Excel Programming | |||
database list | Excel Discussion (Misc queries) | |||
Deleting data in userform and database | Excel Programming |