Welcome to the new platform of Programmers Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use it's exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.
transfering a whole row from access to VB.net
the task is a EPOS system and ive got it that the barcode number (PLU) is sent to access and im trying to return the values of the whole row which PLU code corresponds to it, but it wont work. the data is sent into a textbox
If a = TextBox1.Text Then
rec = mdb.OpenRecordset("ITEMS", DAO.RecordsetTypeEnum.dbOpenTable)
rec.Index = "PrimaryKey"
If rec.NoMatch() Then
MsgBox("Record Not Found")
Return (rec.Fields("PLU", "MANUFACTURE", "ITEM", "ITEM NAME", "SIZE", "COLOUR", "PRICE").Value)
if any more info is need just ask