How to insert new records using the query insert

[rwahdan1978]

Hi



I am tring to create a query of type append to insert new records into existing table!

I choose the table and current database then I put all the fields that I need to insert. Now, I don't know what to put in the caretria of each filed. I tried to put the form fields but nothing happened! What Am I missing? Should I include the primary key or what?

[ano]

u not need a query to update ur table. the query is for manual or vba insert. if u look at ur qry (sql view) it copy it self !
new form with ur table invoiceid is hidden dataview (many records ) or form view (1 record) thats all

[CJ_London]

When you click the append button you are prompted for a table name and it looks like you are trying to append the same data to the same table and since the invoiceID is a PK it would create duplicates which are not allowed. i.e. they are not new records.

Suggest explain exactly what you are trying to do - provide some example data, where does this come from, etc.

If using a form bound to the table appends happen automatically.

If importing data from another table then that is what should appear in the top part of the window

[Welshgasman]

You never include the autonumber field for an append.

[ano]

"t would create duplicates which are not allowed." cj im amazed u say this. he did not include PK so they are added anyway without errors!!!

[CJ_London]

I was referring to the OP's comment in post #1 - 'Should I include the primary key or what?'

[ano]

I was referring to the OP's comment in post #1 - 'Should I include the primary key or what?'

even after several rereads from the questions and ur answers i still confused ur answer because i would answer like welsgasman with the note that PK is autonumber so pk never added in an append / insert . perhaps uk dialect read it as u ment . but i did not .but tnx for the explanation

[CJ_London]

no problem - my response was directed to the OP. I hadn't seen your response when posted