Append query - key violations

Question

Hi

Having this expression in an append query:

“Expr1: ([Forms]![Inleverans]![insatsID])”

Giving a ”D” but I need a Long Integer

Naturally it gives me " didnt add 15 records to the table due to key violations..."

Changed the expression to:

Expr1: CLng([Forms]![Inleverans]![insatsID])

Giving a ”68” - which in this case is the right ID but still I get the same message.

What am I doing wrong?

---

Cheers // Peter Forss Stockholm

Answer 1

I don't see how CLng would convert "D" to 68 - are you sure you didn't use Asc instead?

And if the value is appended to a field with a unique index: are you certain that your expression doesn't produce duplicate values?

---

Regards, Hans Vogelaar (https://www.eileenslounge.com)

Answer 2

the key violation error will fire if you append into a table that has an autonumber key field - - and the append query includes that field...   delete that field from the query so that the table's autonumber will provide the value

so it may not be related to the field you describe; by the way I have confusion on your description of it...