Data validition error in append query

  • Thread starter Thread starter Robert Sykes
  • Start date Start date
R

Robert Sykes

Hello, I have an append query that moves the record on a form based on table
'Members' to another table 'Cancelled Members'.

This worked fine until today, when it has started throwing validation
errors, saying the destination table can't have a Null value in the [Name]
field, as it's a required field in the table properties.

This seems only to work on records created before today, even though the
[Name] has data entered. I just don't understand, anyone out there know what
could be wrong?

--
Notice of Confidentiality:
This transmission contains information that may be confidential and that may
also be privileged. Unless you are the intended recipient of the message
(or authorized to receive it for the intended recipient), you may not copy,
forward, or otherwise use it, or disclose its contents to anyone else. If
you have received this transmission in error, please notify us immediately
and delete it from your system.
 
I've Narrowed it down to one field that seems to be causing the problem, for
some reason the append query sees all the records created prior to yesterday
as having a blank 'Name' field.

No changes were made to either the query or the two tables, anyone know what
could be causing this?

Robert Sykes said:
Hello, I have an append query that moves the record on a form based on table
'Members' to another table 'Cancelled Members'.

This worked fine until today, when it has started throwing validation
errors, saying the destination table can't have a Null value in the [Name]
field, as it's a required field in the table properties.

This seems only to work on records created before today, even though the
[Name] has data entered. I just don't understand, anyone out there know what
could be wrong?

--
Notice of Confidentiality:
This transmission contains information that may be confidential and that may
also be privileged. Unless you are the intended recipient of the message
(or authorized to receive it for the intended recipient), you may not copy,
forward, or otherwise use it, or disclose its contents to anyone else. If
you have received this transmission in error, please notify us immediately
and delete it from your system.
Click to expand...
 
Back
Top