Search results

The number entered is in this format. 1234567-8. I set an input mask to ensure that users enter only in this format. !9999999"-"9 And Indexed yes no duplicates. I have tried the code. It now returns the message. However, the message appears even when there is no duplicate. It is also not...

Hi Alc, I have tried the code you suggested. Private Sub Receipt_BeforeUpdate(Cancel As Integer) If DCount("Receipt", "Receipts", "Receipt = '" & Me!Receipt & "'") > 0 Then MsgBox "Receipt number already exists" Me!Receipt = "" Me!Receipt.SetFocus End If End Sub However, I...

Many thanks for the quick reply ALC. I will try it out.

I have just started to program in Access 2003 and want to use some of the VB Tools. I have a field where the user enters a number, say 1234567-8. I want the database to check that, the number has not been previously entered. If it has, I want the program to return a message to the user...