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