UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Sharepoint Validation Blocking Edit To List Through Access, SharePoint 2013    
 
   
mrouse55
post Apr 18 2019, 01:20 PM
Post#1



Posts: 1
Joined: 18-April 19



We have a SharePoint site and an associated MS ACCESS application. Referrals are put in the SharePoint list through a form that validates the customer number, which must be 9 characters, numeric only. The validation rule works perfectly in SharePoint. However, if any field is changed by an agent from the ACCESS application, the validation for the customer number fails. There are only two fields that the agent can update - one is an "Accepted By" field which is just text with no validation on the SharePoint side, and the other is a "Date Accepted". In the Access application, both fields are populated in the SharePoint list by simply clicking a button.

The validation rule is pretty simple:

=IF(LEN([CustNum])=9,ISNUMBER([CustNum]+0), FALSE)

Once the record is updated from Access and the user tries to move off the record, an error is triggered by the rule, even though the customer number has not changed. It seems that the problem lies in the "IsNumber" function, as I can take that out of the rule and it will work. Any help is appreciated

Best,

MARK ROUSE
Go to the top of the page
 
theDBguy
post Apr 18 2019, 02:42 PM
Post#2


Access Wiki and Forums Moderator
Posts: 76,566
Joined: 19-June 07
From: SunnySandyEggo


Hi Mark,

Welcome to UtterAccess!
welcome2UA.gif

Just a quick question for clarification, is this rule in SharePoint or Access?

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    16th November 2019 - 07:24 PM