Comoare/Check if Records are duplicate using save button

[CoMik]

Hi,



I am new to Access or Vb but then I need to create a record of Users. I created a form with fields containing Username,FirstName,LastName & Email Address wherein the UserName is equals the value of the fields FirstName & LastName. I have a save command button and when I click it, I want it to be able to check if the new entry has a similar UserName that exists in the database, if it exists then it will allow me to edit the UserName and then save the data otherwise will allow me to save it. Can you please help me? I am just a novice in programming. Many thanks in advance.

[ItsMe]

Maybe the Dcount function. This link's title says Method. I guess when you consider Application...
http://msdn.microsoft.com/en-us/libr...ffice.14).aspx

If you get a return >=1 then there is a match. Another option is DAO and the .Findfirst method.

[CoMik]

Hi, Can you please help..I can't get it to work...currently this is my code..the save button is not working...Thanks

Private Sub cmdSave_Click()
If DCount("*", "tblUsers", "UserName=" & Chr(34) & Me.UserName & Chr(34)) > 0 Then
MsgBox "This username already exists!", vbExclamation
Cancel = True
Else
DoCmd.RunCommand acCmdSaveRecord

End If

[ItsMe]

Maybe
If DCount("UserName", "tblUsers", "UserName=" & Me.UserName & )> 0 Then
Here the field UserName is being counted. I usually count the primary key field. I guess a wildcard like in the example I linked to would work too. Never tried it.
Also, your canceling a click event. Not sure what you are trying to cancel here. I see you have the save command but... Usually user input is validated using the before update event handler.