"Microsoft Office Access can't append all the records in the append query"

[Harnav07]

Hi,
I get the following error when I try to save data using append query for the save button in the form.
"Microsoft Office Access can't append all the records in the append query"

Here is some detail:

Private Sub btnSaveToDatabase_Click()
    Dim strSubcontractNumber As String
    Dim strSCNJTag As String
    Dim strSCNJ As String
 
    strSubcontractNumber = txtSubcontractNumber.value
 
    If (txtSCNJTag.value >= 100 And txtSCNJTag.value < 999) Then
        strSCNJTag = txtSCNJTag.value
    End If
    strSCNJ = strSubcontractNumber & "-SCNJ" & "-" & strSCNJTag
    MsgBox "You are about to add  " & strSCNJ & " to the database.  Press OK to proceed.", vbOKCancel, "Adding to database..."
 
    DoCmd.SetWarnings False
    DoCmd.OpenQuery "app_AppendCurrentSCNJ"
    DoCmd.OpenQuery "app_AppendCurrentCostAnalysis"
    DoCmd.OpenQuery "app_AppendCurrentDocuments"
    DoCmd.SetWarnings True
End Sub

Now in all the three append queries there is a field named "SCNJCounter" which has autonumber datatype in table and is primary key field with no duplicate value.
When I click save button on the form it says ok . But the record I saved is not there in the following table and when I checked datasheet view in query is shows new record with same SCNJCounter value. when I try to run the query it returns the error above.I know records are not saved in table because SCNJCounter is not incrementing but don't get why.
Your help will be greatly appreciated.
Thank you in advance...

[NeoPa]

Your error message is not complete. You included only the least helpful part and omitted the important details explaining how many and why records failed.

Your code has not been taken from your project (unless you have used a variable called Value and spelled it with a lower-case 'v' to confuse Access). It's necessary that you follow these instructions carefully when posting code - Before Posting (VBA or SQL) Code.

You give us no real information that pertains to your problem that makes sense without your database to hand. No indication of what your queries do, and not even any indication of which line the error message you've half-shared is triggered by (I'm assuming it's only a single query you're referring to. I can't imagine anyone thinking that describing a problem which is repeated over three queries as if it were only one, makes any sense).

If you can fill in the missing information intelligently then we may be able to help.