validation rule violation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am getting a "validation rule violation" error message when I try to run the following update query. There are no validation rules on either of the tables involved. What causes this error? I am including the SQL for the query below; let me know if you need additional info to help me. I am working in Access 2002, with a db recently converted from Access 97

Thanks
John B

UPDATE tblSampleReq_Upd INNER JOIN tblSampleReq ON tblSampleReq_Upd.ReqID = tblSampleReq.ReqID SET tblSampleReq.Season = tblSampleReq_Upd.Season, tblSampleReq.LocID = tblSampleReq_Upd.LocID, tblSampleReq.OrderGp = tblSampleReq_Upd.OrderGp, tblSampleReq.Name = tblSampleReq_Upd.Name, tblSampleReq.ShipTo = tblSampleReq_Upd.ShipTo, tblSampleReq.Stage = tblSampleReq_Upd.Stage, tblSampleReq.QtyLeft = tblSampleReq_Upd.QtyLeft, tblSampleReq.QtyRight = tblSampleReq_Upd.QtyRight, tblSampleReq.Flats = tblSampleReq_Upd.Flats, tblSampleReq.Mediums = tblSampleReq_Upd.Mediums, tblSampleReq.ChannelSet = tblSampleReq_Upd.ChannelSet, tblSampleReq.GenderSet = tblSampleReq_Upd.GenderSet, tblSampleReq.ReqStatus = tblSampleReq_Upd.ReqStatus, tblSampleReq.ReqModDate = Now(), tblSampleReq.ReqComments = "Updated per: " & [Enter Update Source]
 
Open your table in design view, and look for this kind of thing:

-Are any of the fields marked Required (lower pane)?

- If a field has Allow Zero Length set to No (as it should) it is possible
you are trying to assign a zero-length string?

- Are any fields marked, "Indexed (No Duplicates)"?

- Are any fields foreign keys, where relational integrity could be blocking
the value?

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

John B. said:
I am getting a "validation rule violation" error message when I try to run
Click to expand...
the following update query. There are no validation rules on either of the
tables involved. What causes this error? I am including the SQL for the
query below; let me know if you need additional info to help me. I am
working in Access 2002, with a db recently converted from Access 97.
Thanks,
John B.

UPDATE tblSampleReq_Upd INNER JOIN tblSampleReq ON tblSampleReq_Upd.ReqID
Click to expand...
= tblSampleReq.ReqID SET tblSampleReq.Season = tblSampleReq_Upd.Season,
tblSampleReq.LocID = tblSampleReq_Upd.LocID, tblSampleReq.OrderGp =
tblSampleReq_Upd.OrderGp, tblSampleReq.Name = tblSampleReq_Upd.Name,
tblSampleReq.ShipTo = tblSampleReq_Upd.ShipTo, tblSampleReq.Stage =
tblSampleReq_Upd.Stage, tblSampleReq.QtyLeft = tblSampleReq_Upd.QtyLeft,
tblSampleReq.QtyRight = tblSampleReq_Upd.QtyRight, tblSampleReq.Flats =
tblSampleReq_Upd.Flats, tblSampleReq.Mediums = tblSampleReq_Upd.Mediums,
tblSampleReq.ChannelSet = tblSampleReq_Upd.ChannelSet,
tblSampleReq.GenderSet = tblSampleReq_Upd.GenderSet, tblSampleReq.ReqStatus
= tblSampleReq_Upd.ReqStatus, tblSampleReq.ReqModDate = Now(),
tblSampleReq.ReqComments = "Updated per: " & [Enter Update Source];
 
Back
Top