|
-
Dec 10th, 2001, 11:26 AM
#1
Thread Starter
New Member
Importing listbox text into a database
The thing i asked about in the last thread works now..
Private Sub cmdImport_Click()
Dim J As Integer
Dim ArtNr As Single
J = 1
For J = 1 To lstArt.ListCount
daBesteld.Recordset.AddNew
daBesteld.Recordset!ArtikelNr = "test"
daBesteld.Recordset!Aantal = "1000"
daBesteld.Recordset!TotPrijs = "1500"
daBesteld.Recordset!BestelDat = Date
daBesteld.Recordset!Ontvangen = "Nee"
daBesteld.Recordset.Update
Next
End Sub
This is the code that I use now.. but now i want the right values on the right place in the database..
frmLijst.lstArt.AddItem (txtArtNr.Text & vbTab & txtNaam.Text & vbTab & txtAantal.Text & vbTab & TotPrijs)
That is the code that I use to add products into the listbox.. How can I get that information back when a button is pressed, so I can import it into the database?? Please help me 'cause I'm still stuck with this thingie, and cant go on untill I've got it working right.. Thanks for your time..
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|