Validation

[RussKass]

Hi,
I would like to perform a validation check on a field (Employee/Staff Number) there should not be duplicate entries in this field so i would like for a check to be performed when the next field is clicked then a msg displayed saying "Staff Number already exists"
Any sample code would be appreciated

Regards

[DataMiser]

Typically this would be done with a lookup query assuming that your data is stored in a database.

[RussKass]

yes my data is in an access database, any code in mind?

[WoF]

If in your access table the field is an index field with no duplicates, you can proceed like this:
Try to write the record to the table. If the entry is a duplicate the write will be rejected, returning an error code (or even throw up an error). You can trap this error and write an apropriate reaction like a messagebox saying "no duplicates".

[HanneSThEGreaT]

Correct. This needs to be handled through the database. Full stop.

[ComITSolutions]

Hi,
I would like to perform a validation check on a field (Employee/Staff Number) there should not be duplicate entries in this field so i would like for a check to be performed when the next field is clicked then a msg displayed saying "Staff Number already exists"
Any sample code would be appreciated

Regards

First of all you should try to write some code, based on your requirement and if you get struck in between , there are many gurus in this forum to guide.

Private Sub txtempNo_Validate(Cancel As Boolean)
    Dim TmpRs As New ADODB.Recordset
    TmpRs.Open "Select EmpNo From EmpDetails  Where EmpNo=" & txtempNo.Text, Conn, adOpenDynamic, adLockBatchOptimistic
    If Not TmpRs.EOF Then
        MsgBox "Staff Number already exists"
        Cancel = True
    End If
End Sub