Recent content by dah_axs

Thank you, I am learning, but not quite there. I have the code below, but my syntax seems to be off and I do not know how to add an allow Null values exception. I am entering this in the Immediate window. DoCmd.RunSQL "ALTER TABLE tblmasterlocation ADD CONSTRAINT item_ck_constraint CHECK (ITEM...

I have downloaded the sample file, but cannot find the MyConstraint1 code/ expression. I am in access 2000. Thank You