DataBase

[daleG]

Hello,
I am working with a microsoft Access'97 (OLE DB) database. I have no experience with this. I need to find the 1 row that matches variables in 5 different colums. Then extract a couple of fields from (found row) and set them to a textbox.
I could really use some help getting started. I tried to use a sample from another post but had no luck. Can I use SQL statements with a OLE DB? If so, how?


Dim srch As String
srch = "Tool diameter= '" & dia & "'"
Dim fndrow As DataRow() = ToolsDataSet1.Tables("Tool table").Select(srch)

[daleG]

Ok I got this code to work:

Dim srch As String
srch = "RPM= '" & dia & "'"
Dim fndrow As DataRow() = ToolsDataSet1.Tables("Tool table").Select(srch)


I just cant get it to work if my colum name has 2 or more words like this one:

Dim srch As String
srch = "Tool diameter= '" & dia & "'"
Dim fndrow As DataRow() = ToolsDataSet1.Tables("Tool table").Select(srch)

help Please!!