Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Dim dbcon As New OleDb.OleDbConnection Dim dbcomm As New OleDb.OleDbCommand Dim dbreader As New OleDb.OleDbDataReader Dim dbProvider As String Dim dblookupString As String dbProvider = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\database.accdb;Persist Security Info=False;" dbcon.ConnectionString = dbProvider dbcon.Open() dblookupString = "Select * from tblinventory where ItemBarcode = " & textAddItem.Text dbcomm.Connection = dbcon dbcomm.CommandText = dblookupString dbreader = dbcomm.ExecuteReader() While (dbreader.Read()) MsgBox(dbreader("ItemName")) 'Show data in a Message Box End While dbcon.Close()
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|vb.net deleting excel sheet in workbook||11||36|
|MS Access How can I add a relative path to my VBA PDF output that will work for most Windows computers?||4||32|
|Win 10 Automation Error with .doCmd in Access||2||32|
|chrome says SHA256 algorithm is weak even after i configure my website to use SHA256 certificate||5||44|