Error msgbox '31005' - Access failed......
Posted on 2007-11-25
txtText1 is a form field bounded to tblMain. tblMain.Test1 is a mandatory field.
User entered a data in a text box and then removed it later for one reason or the other. User proceded to enter all other fields but skips txtTest1.
User eventually forgot to re-enter data in the txtTest1 form field. When user clicked the btnAddNew record to advance to a new record screen a msgbox flagged telling user that txtTest1 must be filled.
Also immediately and before user gets the chance to enter data in the txtTest1 form field, another Microsoft Access Error '31005' dialogbox immediately popup with the following message :
"Access failed to evaluate one or more expressions because '|'
was referenced in an expression. Only functions and properties
that are considered to be safe are allowed in expressions when
Access runs in sandbox mode."
User does not know what this new message means and how to disable the msgbox from showing in the future.