Forum Discussion
Solved
Excel VBA to filter a table based on multiple search criteria entry in ActiveX Control Textbox
Hello All, (This is a development of the thread Excel 365 ActiveX Textbox for "Search as you type" not working on second monitor - Microsoft Community Hub) I am seeking a solution to the belo...
That is unavoidable; the code has to do a lot of work. In that case, I'd use a command button to filter, instead of reacting to every keystroke.
Is it possible to achieve that without adding a new column as I am using a power query output table?
How about play with database?
//select * from multiple_criterias_filter;
cli_add_html~
<form method="post" action="?p=Tools/DisTbl&g=sql" autocomplete="on" autofocus="autofocus" >
<input type="search" name="Items">
<input type="submit" id="submitForm" value="Do Filter" style="height:2em">
</form>;
cli_add_php~
//$_POST["Items"]="Fix,lig";
if(isset($_POST["Items"])){
$arrItems=explode(",",$_POST["Items"]);
$s=array_reduce($arrItems,function($carry,$v){
$out=$carry." and "."Items like '%$v%'";
return $out;
});
$key=str_replace(',','|',$_POST["Items"]);
$sql="select PO,udf_highlightbg('$key',Items) Items,UOM,Qty,Unit_Price,Total_Price from multiple_criterias_filter where 1=1 $s";
echo $_POST["Items"];
\multiquery\display_table($sql);
}
;