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.GetFormItem Value('For ms!Navigat ion Form!NavigationSubform.For m!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!
Macro Name = Macro1
Action Name = Set Filter
Arguments
'=SQL.LIKE(OpsNo, CONCATENATE.DB(\"*\", ' + Access.Actions.GetFormItem
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.