Solved

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

Posted on 2007-11-25
7
990 Views
Last Modified: 2013-11-28
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
Comment
Question by:billcute
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 46

Accepted Solution

by:
tbsgadi earned 200 total points
ID: 20345474
Hi billcute,

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


Good Luck!

Gary
0
 
LVL 75

Assisted Solution

by:DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 200 total points
ID: 20345998
Bill:

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

mx
0
 
LVL 57

Assisted Solution

by:Jim Dettman (Microsoft MVP/ EE MVE)
Jim Dettman (Microsoft MVP/ EE MVE) earned 100 total points
ID: 20346680

  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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 4

Author Comment

by:billcute
ID: 20349110
Mx:
By Setting to low seems okay but what are the consequences?
0
 
LVL 4

Author Comment

by:billcute
ID: 20349112
tbsgadi:
Your suggestions seems to provide better understanding of the problem.
0
 
LVL 75
ID: 20351012
"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
 
LVL 4

Author Comment

by:billcute
ID: 20354017
MX
Thanks
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Undo Button 1 35
Access Query: Text to Date 10 34
MS Access VBA How To Decompress a Gzip Response From a HTTP Request 4 34
ms/link form - subform field not recognised 3 16
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question