• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1087
  • Last Modified:

Error msgbox '31005' - Access failed......

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."

Question:
User does not know what this new message means and how to disable the msgbox from showing in the future.
0
billcute
Asked:
billcute
3 Solutions
 
tbsgadiCommented:
Hi billcute,

Checkout http://support.microsoft.com/kb/294698


Good Luck!

Gary
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Bill:

Open Access:
menu >>Tools>>Macro>>Security...
Se to Low.

mx
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:

  Not sure your going to find the answer to this as I believe it's an internal bug your running into.

  Access uses the | (vertical pipe) as a place holder for expressions as part of its internal processing.  When you see one in a error message, it generally means trouble.  In the past, I've actually had to code around it.

  Try turning off the macro warning first as the others have suggested.  That may clear it up.  After that, you'll need to take apart the process that is occuring when the error occurs and figure out if you can change something or do something differently not to trigger the error.

JimD
0
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
billcuteAuthor Commented:
Mx:
By Setting to low seems okay but what are the consequences?
0
 
billcuteAuthor Commented:
tbsgadi:
Your suggestions seems to provide better understanding of the problem.
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
"By Setting to low seems okay but what are the consequences?"

In theory, if set to Low, a 'virus' (not really) could be loaded. What that actually means is that someone could send you an MDB with an AutoExec Macro that runs a function that executes the Shell Command with deletes everything on your hard drive.  This happened once circa 2002 which is why M$ implemented the macro (in)Security mess for A2003. It is and always has been a joke, because it is *easily* circumvented a number of ways ... thus ... False Security.  IF ... it's Your MDB and you have control over it and you and your users are the only ones using it, then you don't really have anything to worry about.  IF ... *someone else* sent you a different MDB with the above scenario ... then you could have a problem ... because the Macro Setting is Global for Access.

mx
0
 
billcuteAuthor Commented:
MX
Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now