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

  • Thread starter Thread starter Pietro
  • Start date Start date
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?
 
Type conversion failure is a data type. Apparently you have a mismatch in
those fields.
 
Arvin Meyer said:
Type conversion failure is a data type. Apparently you have a mismatch
in those fields.
Click to expand...

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?
Click to expand...
Click to expand...
 
Back
Top