Error MS Access: One or more values are prohibited by validation rules

Asked By Malina Foster 10 points N/A Posted on - 02/02/2012

Hello guys

While I was running MS Access I put the quantity in a table along with clicking on a new table and then I chose both tables to make a comparison between data. I just wanted to put the outcome in a fresh table; however, ended up with the following error message reading, “One or more values are prohibited by validation rules”

Microsoft Access

One or more values are prohibited by the vatidation rule LiI °[FAL] #### set for ‘Members.MembershipNumber. Enter a value that the expression for this field can accept.

OK Help

Please I want a solution for this problem. Anyone here who can help me solve it?? Thanks in advance.

• Status: Open
• Question Views: 3670
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Access

Answered By tibor.tokie 25 points N/A #104492

Error MS Access: One or more values are prohibited by validation rules

Dear Malina Foster

According to the Microsoft office access 2007 developer reference support page, the error message you got is marked as "Error 3317: One or more values are prohibited by the validation rule '<rule>' set for '<name>'. Enter a value that the expression for this field can accept". The cause of this error is that the validation rule property you use "Like "[FAL]# # # #" for that field contains an expression which limits the values that should be entered in that field. Have a look of the value you enter and make sure that it's not prohibited by your expression.

Hope this may help you.

Best of luck

About tibor.tokie

Questions
1

Answers
157

Best Answers
24

• Vote Up 0 Vote Down

• Posted on - 02/09/2012
• Question Category: MS Access