I have a built a simple append query which appends a temp table to another table. The fields and all their properties are identical, but i am getting validation error messages. Am I missing something or is it just me with my monday head on?? could the Date field have anything to to with it?
Append Query Failure
- Thread starter Jonno
- Start date
R
Rich
Guest
Are you trying to append an auto number?
CJBIRKIN
Drink!
- Local time
- Today, 19:17
- Joined
- May 10, 2002
- Messages
- 255
Hi
Don't know about you but when i have this problem 99 times in 100 its a field in the main table set to Required = true. Usually a text field, for some reseason when ever i create a table the text fields are always set to that. Anyway back to your problem. I would double check that;
a) You genuinley haven't got two different field types like memo not text or single not integer etc
b)Your main table fields allow nulls if there are any in your temp table.
c) That you haven't got a validation rule that's breached i.e >=0 and your trying to enter -1
d) Your not trying to enter a duplicate value into a field that's set to indexed = yes (no duplicates)
If that don't work i haven't got a Scooby.
Chris
Don't know about you but when i have this problem 99 times in 100 its a field in the main table set to Required = true. Usually a text field, for some reseason when ever i create a table the text fields are always set to that. Anyway back to your problem. I would double check that;
a) You genuinley haven't got two different field types like memo not text or single not integer etc
b)Your main table fields allow nulls if there are any in your temp table.
c) That you haven't got a validation rule that's breached i.e >=0 and your trying to enter -1
d) Your not trying to enter a duplicate value into a field that's set to indexed = yes (no duplicates)
If that don't work i haven't got a Scooby.
Chris
