[AccessD] You cannot record your changes because...

William Benson (VBACreations.Com) vbacreations at gmail.com
Mon Oct 24 13:31:50 CDT 2011


Oh, did I say that was the worst part ...? lol. The underlying table is a
linked excel file so I don't think there is anything I can do about it?!!

-----Original Message-----
From: William Benson (VBACreations.Com) [mailto:vbacreations at gmail.com] 
Sent: Monday, October 24, 2011 2:30 PM
To: Access Developers discussion and problem solving
Subject: RE: You cannot record your changes because...

The worst past of this is that I get the same error just testing a field on
the subform:

Me.Control("Postal_Code").value

I suspect that the underlying record has a value of #NUM after a field
failed to import all data correctly.

So I guess maybe if I destroy all the #NUM values in the data the subform
which is based on that table might stop failing... I will try and report
back.


-----Original Message-----
From: William Benson (VBACreations.Com) [mailto:vbacreations at gmail.com] 
Sent: Monday, October 24, 2011 2:24 PM
To: Access Developers discussion and problem solving
Subject: You cannot record your changes because...

I have a form with a data sheet subform. On the current event of the
subform, the values from some of the fields in the data sheet subform are
put into the unbound controls on the parent form.

This was working fine now all of a sudden the form won't open, I get a
message 

"You cannot record your changes because a value you entered violates the
settings defined for this table or list (for example, a value is less than
the minimum or greater than the maximum). Correct the error and try again.

Now, as far as I know I have no validation settings of this kind, and the
table which the subform is based on is a linked table (Excel range).

Does someone have some suggestions for what is possibly causing this?




More information about the AccessD mailing list