Explain these errors please

  • Thread starter Thread starter Kate
  • Start date Start date
K

Kate

I get the message Microsoft Access can't append all the
records in the append query.

Microsoft Access set 1 field to Null due to a type
conversion failure, didn't add 0 records to the table due
to key violations, 0 records due to lock violations and 0
records due to validation rule violations
Do you want to run the action query anyway etc.

What does this mean? Is there just one error, i.e. the
conversion failure so it adds my records?

What might cause the conversion error? My table is keyed
on an AutoNumber field, 2 of the fields conatin checkboxes
from a form and one conatins a date assigned using date()

Thanks in advance
 
I get the message Microsoft Access can't append all the
records in the append query.

Microsoft Access set 1 field to Null due to a type
conversion failure, didn't add 0 records to the table due
to key violations, 0 records due to lock violations and 0
records due to validation rule violations
Do you want to run the action query anyway etc.

What does this mean? Is there just one error, i.e. the
conversion failure so it adds my records?
Click to expand...

That's correct: only one error.
What might cause the conversion error? My table is keyed
on an AutoNumber field, 2 of the fields conatin checkboxes
from a form and one conatins a date assigned using date()
Click to expand...

What are the datatypes of the fields that you're trying to fill? and
what's in the form controls? A Checkbox would ordinarily be used to
fill a Yes/No field.

Perhaps you could post the SQL of the query.
 
Back
Top