InfoPath 2010

Re: "Is Not Equal To" Validation of Access Data not working

Bianca — Thu, 04 Apr 2013 12:13:55 GMT

Hi Jimmy

That works! Thanks, that's great :)

Re: "Is Not Equal To" Validation of Access Data not working

Bianca — Thu, 04 Apr 2013 12:12:54 GMT

Re: "Is Not Equal To" Validation of Access Data not working

Jimmy — Thu, 28 Mar 2013 13:48:14 GMT

Try using EQ_NAME for the left side of the comparison (using the Select field or group... option) and with the field selection dialog still open, change the Select: dropdown to All occurrances of EQ_NAME. Then use are not equal to for the comparison and select field1 for the right side.

Re: "Is Not Equal To" Validation of Access Data not working

Bianca — Thu, 28 Mar 2013 09:15:20 GMT

Hi Hilary, thanks for your reply, sorry I have only just seen it.

The expression is

. != xdXDocument:GetDOM("TOTALPLANT_OM_LIMIT_SET")/dfs:myFields/dfs:dataFields/d:TOTALPLANT_OM_LIMIT_SET_Query/@EQ_NAME

Re: "Is Not Equal To" Validation of Access Data not working

Hilary Stoupa — Fri, 15 Mar 2013 14:47:35 GMT

Hi - can you change the first drop down in your condition to "The expression" and paste the returned XPath into a reply?

"Is Not Equal To" Validation of Access Data not working

Bianca — Wed, 13 Mar 2013 11:24:42 GMT

I am building a form which is linked to an Access Database. I wish to create a text box which users will manually enter values into, and which a validation rule will then check against a field in an Access Table or Query.

I managed this by adding a rule which has condition: field1 Is Not Equal to EQ_NAME (where EQ_NAME is the name of the field in the access database)

and the rule type is Validation

However, whether I enter a value into the text field which is a valid value or not, the validation always brings up an error.

Strangely, when trying to do it the other way round, i.e. use the "Is Equal To" rather than "Is Not Equal To" the validation works as expected. This suggests that it might be a configuration error within Infopath itself... but is there any way around this?

Thanks, Bianca