Link to home
Start Free TrialLog in
Avatar of wagebhart
wagebhart

asked on

Enterprise SharePoint-Query error "Failed to filter result"

Using MS Access 2010, I published a small MS Access database to my Enterprise SharePoint site. I'm using a macro to filter results of table based on the value of a combo box. The macro works in Access but not in SharePoint. I receive a message stating "Query error-Failed to filter result". Details below

Macro Name = Macro1
Action Name = Set Filter

Arguments

'=SQL.LIKE(OpsNo, CONCATENATE.DB(\"*\", ' + Access.Actions.GetFormItemValue('Forms!Navigation Form!NavigationSubform.Form!Combo28',true) + '))'

Error Number = 2950

I added my site as a Trusted Site in database security setting. I opened a module and checked the References. None are missing.

Any help would be greatly appreciated!
ASKER CERTIFIED SOLUTION
Avatar of wagebhart
wagebhart

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial