As per my comment, you need to move the recordset to the record you want to delete, assuming that Serial_No is a unique identifier;
Private Sub Button6_Click(sender As Object, e As EventArgs) Handles Button6.Click
Rss = New ADODB.Recordset
Rss.Open("SELECT * FROM Employee WHERE Serial_No = '" txtSNo.Text.Trim "'", CON, CursorTypeEnum.adOpenDynamic, LockTypeEnum.adLockOptimistic)
If Rss.BOF = True And Rss.EOF = True Then
MsgBox("Record Not Found")
Else
Rss.Delete
MsgBox("Record Deleted Successfully", MsgBoxStyle.Information, strprojectname)
End If
Rss.Close()
End Sub