Modifying an existing embedded macro

[ricobano]

I have an embedded macro in an access web database and i need to modify one of the conditions but have run into some issues. The condition below is puzzling me

[searchable] Like "*" & [TempVars]![tmpSearch] & "*"

What does searchable refer to in this expression? Is [Searchable] an attribute of a column in a table? I need to add more columns into the search to make it useful. Can i add more columns to the [searchable] grouping (if thats what it is)? If so how can i do that

 

[Beetle]

[searchable] is likely a field in the record source of an object (i.e. a form), but hard to say for sure because we can't see your app. If you want to post back with more details or a sanitized, zipped copy of your app I can look into it further.

 

[AccessJunkie]

Hi,

Searchable is a calculated column in the query that serves as the record source for the form in question. If you open up that query you'll see a column called Searchable. That column uses an expression to concatenate the values of many fields in the underlying table. If you open that query in datasheet view, you'll see what it is doing.

The UI macro logic then uses that column to set a filter for the form in Form view to display values that match, or are close to a match actually, the value you typed in the Search text box.

If you want to add more columns to the Searchable column, just modify the expression in the query to include the extra fields in the table.

--------------------
Jeff Conrad - Access Junkie - MVP Alumnus
SDET II - Access Test Team - Microsoft Corporation

Author - Microsoft Access 2013 Inside Out (coming soon)
Author - Microsoft Access 2010 Inside Out
Co-author - Microsoft Office Access 2007 Inside Out
Access 2007/2010 Info: http://www.AccessJunkie.com

----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
----------

 

[ricobano]

Thanks guys that pointed me in the right direction.

 

[AccessJunkie]

You're welcome, glad we could help.
Good luck with your project.

--------------------
Jeff Conrad - Access Junkie - MVP Alumnus
SDET II - Access Test Team - Microsoft Corporation

Author - Microsoft Access 2013 Inside Out (coming soon)
Author - Microsoft Access 2010 Inside Out
Co-author - Microsoft Office Access 2007 Inside Out
Access 2007/2010 Info: http://www.AccessJunkie.com

----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
----------