Solved Error 3022

[jdraw]

And what exactly happened just before Its work now...?

 

[gemma-the-husky]

we may never know. I expect one of us solved the enigma.

 

[smtazulislam]

we may never know. I expect one of us solved the enigma.

No sir, You're both help me.

SELECT VisaSN([Forms]![frmEmployeeEdit] REPLACE VisaSN([Forms]![frmEmployeeEdit1].
Eugene-LS said, RecordSource checking & Jdraw comment then I check all query subform then I find there a mistake. Why renamed I don't know.

Almost 5 hours later find, tblEmployees in field EmployeeNID is not Duplicate. But found two NID numbers is Duplicate. I dont know how to save this Numbers in table. Its have Index. no idea ?

 

[smtazulislam]

Thanks all for support...

 

[The_Doc_Man]

But found two NID numbers is Duplicate. I dont know how to save this Numbers in table. Its have Index. no idea ?

The first and most important question is whether this NID number SHOULD be duplicatable or unique. If it must be unique, then you need to determine WHY you were trying to enter a duplicated number in that column. Before you go crazy trying to jam-cram something into a table that seems to violate the constraints, first figure out if that was what you really were trying to do ... AND WHY. Then, if the no-dups rule is real and the apparent duplicate entries are really there, figure out WHY they were there. What you have is an OPERATION problem first. THEN maybe it is a data problem.

Stated another way, you ask yourself the question "What did I do to deserve this?" and then don't treat it as a rhetorical exercise.

 

[gemma-the-husky]

SELECT VisaSN([Forms]![frmEmployeeEdit] REPLACE VisaSN([Forms]![frmEmployeeEdit1].

In passing, I don't think I have ever seen SQL with "replace" as a command before. Is this a common usage?