Hello every1
I have mostly read all threads on errors when appending records but i have no solution
im trying to add new records from one table to another, i can do this successfully but i get the following error
"Microsoft Office Acess set 0 field(s) to Null due to type conversion failure, and it didnt add 5 record(s) to the table due to key violations, 0 record(s) due to lcok violations, and 0 record(s) due to validation rule violations.
Do you want to run the query anyway?
To ignore the error(s) and run the query, click yes
For an explantion of the causes of the violations, click Help"
all i did was copied table1 and made table2 and when i want to add new records it does add the records but always with this error message
Is there any way i can get rid of this message and why is this message popping up??
im quite new to ms access
thanks
I have mostly read all threads on errors when appending records but i have no solution
im trying to add new records from one table to another, i can do this successfully but i get the following error
"Microsoft Office Acess set 0 field(s) to Null due to type conversion failure, and it didnt add 5 record(s) to the table due to key violations, 0 record(s) due to lcok violations, and 0 record(s) due to validation rule violations.
Do you want to run the query anyway?
To ignore the error(s) and run the query, click yes
For an explantion of the causes of the violations, click Help"
all i did was copied table1 and made table2 and when i want to add new records it does add the records but always with this error message
Is there any way i can get rid of this message and why is this message popping up??
im quite new to ms access
thanks
