Search results

Well there only to enter that form when they need to create there account and this buttons already in the Details Tab. Joshua

Ok So how do i stop it from Saving When its an incorrect Key or even delete the Record if its invalid? Joshua

Ok Ive done everything but now, No idea how but its saving the Record even if its wrong have no idea why because it hasnt done it befor? Joshua

how do i set the Colour of the textbox as well as .setfocus?? Joshua

Private Sub cmdCA_Click() 'Checks Username Field Has Been Filled in If IsNull(Me.txtUsername) Then MsgBox "Please Enter a Username", vbOKOnly, "Information Required" Me.txtUsername.SetFocus Exit Sub End If 'Checks if there is already a username the same If...

Works thanks guys :) Joshua

so its better to use <> then = for what i want to do?

Whats the difference between If Me.txtEmployeeKey.Value <> DLookup( and If Me.txtEmployeeKey.Value = Dlookup( ??

Yes that makes sense but the Form run perfectly? but i get what your saying and have changed it to If Me.txtEmployeeKey.Value = DLookup("[EmployeeKey]", "tblEmpKey", "EmployeeKey ='" & [EmployeeKey] & "'") but im still stuck with the user being informed when it is already used? Joshua

What do you mean it will never come back with Incorrect Employee Key or username already in use Because this is not the case as it comes up with that when uve entered it wrong and when i enter it right it procceds

it works perfectly but ive set the employeekey in my table to Indexed(Yes no Dups) and what happens is it does not save if there is a value the same which is what i want but i want to be notified

Ok Basically Ive got a table with a field that is a yes/no named Used how to i alert the user when theirs already an account with that Key? My Codeis below Help would be great Private Sub Command4_Click() If IsNull(txtEmployeeKey) Or txtEmployeeKey = "" Then MsgBox "Please Enter...