K
Keith
Check the data types of the fields. The list of fields
being filled in has to match the order and data types of
the values being appended. When this message appears,
the problem is usually due to incompatible data type or
field ordering.
Another possibility - Are you compiling the list of
values from controls on a form. If you are, then it is
possible you are stringing a null between a couple of
delimiters (for instance, building a literal date value
like '#' & <fieldvalue> & '#'), where the field value is
null. The resultant entry would be '##'. If this were
inserted into a date field then the error you are
receiving would be the result.
If you can't find the offending field, reply with the
full SQL as you have it in the code and the table
structure so that we can get a better look at the problem.
being filled in has to match the order and data types of
the values being appended. When this message appears,
the problem is usually due to incompatible data type or
field ordering.
Another possibility - Are you compiling the list of
values from controls on a form. If you are, then it is
possible you are stringing a null between a couple of
delimiters (for instance, building a literal date value
like '#' & <fieldvalue> & '#'), where the field value is
null. The resultant entry would be '##'. If this were
inserted into a date field then the error you are
receiving would be the result.
If you can't find the offending field, reply with the
full SQL as you have it in the code and the table
structure so that we can get a better look at the problem.