Expand|Select|Wrap|Line Numbers
- Dim counter As Integer
- counter = 0
- adoEmployee.Recordset.MoveFirst
- Do While adoEmployee.Recordset.EOF
- MsgBox (adoEmployee.Recordset.Fields(0).Value)
- If txtInputID.Text = adoEmployee.Recordset.Fields("EmployeeID").Value Then
- counter = 1
- End If
- adoEmployee.Recordset.MoveNext
- Loop
- If counter = 0 Then
- MsgBox "Employee ID does not exist", vbInformation, "Find Failure"
- txtInputID.Text = ""
- txtInputID.SetFocus
- adoEmployee.Recordset.MoveFirst
- Exit Sub
- End If