Set (9) fields to Null due to type conversion failure !!!!

P

Pietro

Hi,
I'm trying to append query1 to table2,one of query1 's field is an
external one called "Language",the query gets this field from [forms]![update
cap]![language],when i run the append query,with the form "update cap" open
and the field "Language" is not null,i get an error message "Customer Support
cannot update all records in the append query,Customer Support set (9) fields
to Null due to type conversion failure,(0) records due to ....etc."
Although ,when i check the append query in datasheet view,i can see the
language field that already got the data from [forms]![update cap]![language].
The field "language" of table1 is set to text (255)
Can anybody help?
 
A

Arvin Meyer [MVP]

Type conversion failure is a data type. Apparently you have a mismatch in
those fields.
 
C

Clif McIrvin

Arvin Meyer said:
Type conversion failure is a data type. Apparently you have a mismatch
in those fields.

Also, the error message doesn't tell you which field (or fields) had the
type conversion error -- it may not be the language field at all.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

Pietro said:
Hi,
I'm trying to append query1 to table2,one of query1 's field is an
external one called "Language",the query gets this field from
[forms]![update
cap]![language],when i run the append query,with the form "update
cap" open
and the field "Language" is not null,i get an error message "Customer
Support
cannot update all records in the append query,Customer Support set
(9) fields
to Null due to type conversion failure,(0) records due to ....etc."
Although ,when i check the append query in datasheet view,i can see
the
language field that already got the data from [forms]![update
cap]![language].
The field "language" of table1 is set to text (255)
Can anybody help?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top