Parameter Query Issue in Access Services

[serena2112]

Hello!

I've spent the past several days searching here and elsewhere online for a solution to this problem, but nothing has worked yet for my case.

I've used Access Services to upload and link a database of client research questions (I work for a research services firm) and solutions on one of my company's Sharepoint 2010 team sites. The tables were built from an import of an Outlook 2010 email Inbox folder. This was a one-time-only import; no Access table links were made with the Outlook folder.

My team would now like to be able to search each field using an advanced search form. Steps taken so far:

• I created a parameter query based on the Inbox table using: Like "*" & [parametername] & "*" as the criteria for each field (changing the parameter name accordingly).
• Created a bound results form (frmResults)
• Created an unbound search form, naming each field txtSubject, txtFrom, etc.
• Created a search button with a BrowseTo macro that defines parameters

A scrubbed version of the database is attached. I separated the search form from the Navigation form to avoid subform issues, but Access seems to still be looking for this form when I open the db. The search itself only brings up a blank results form. Have I missed a step? Thank you very much for any feedback!!

 

[AlexHedley]

Original

Like "*" & [parametername] & "*"

Try adding single quotes around the search.

LIKE "'*" & [parametername] & "*'"

I take it [parametername] is a String?

 

[serena2112]

Thank you for your prompt response! I'm still seeing the "Failed to filter result" error when using the search form in Sharepoint 2010. [parametername] is a string, for example [txtSubject].