- Dim myConnection As ADODB.Connection
- Dim Manu As ADODB.Recordset
- myConnection.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & dbloc
- Set Manu = myConnection.Execute("SELECT * FROM installatie WHERE PC_ID LIKE text")
The above code works fine, but i wan't a query that checks if a record excists... how do i do that?