I want to stop users from being able to save a duplicate record in my Access database. I thought of using RecordsAffected, but I can't figure out how to get it to work.
SelectSearchString = "SELECT * FROM Breakdown WHERE BFrom = " & txtFrom.Text ' & " AND BTo = " & txtTo.Text Dim Con As New OleDbConnection(BCalc_ConnectionString) Dim Search As New OleDbCommand(SelectSearchString, Con)
That's how I've started. I want to be able to use the result of the RecordsAffected as a parameter in an IF statement so that
IF Search.records affected = 0 THEN Insert records ELSE Display msgbox telling user that duplicate records aren't allowed.
Any help would be appreciated