I found a much better way, which will prevent me using VBA codes.
The better way is using Instr() function.
INSERT INTO tempTableA ( ID, Keyword )
SELECT DISTINCT tblSearchTerm.SearchTermID, tblSearchTerm.[Customer Search Term]
FROM tblSearchTerm, tblBrands
WHERE...
Hi The_Doc_Man,
I have implemented a solution based on Pat's idea.
But, I will test your solution and I will let you know of the result.
Thanks for helping.
I thank you all guys for helping me and the problem was solved.
I selected the solution suggested by Pat Hartman.
To help other MS Access user who have encountered similar problem, I will post below the solution I have done.
Before I proceed, I would like to share my actual objective on this...
Using VBA, what should I do to filter Table A by using Table B as filter? Any records in Table A that contains words found in Table B should be removed in the final list. (please see attached image for more details).
Thanks Pat for the answer.
Your answer makes sense.
My only concern using VBA is memory overload.
TableA consist of thousand keywords and TableB consist of hundred keywords.
Per record of TableA will loop to the hundred keywords of TableB. And taking into account also that I need to split...
Hi arnelgp,
I tried to change the syntax by adding an ampersand (&) and double quotation mark before the word "Not" and after the last close parenthesis. See the changes below:
select [long tail keyword] from TableA, TableB where " " & TableA.[Long tail keyword] & " " & "Not (Like "* " &...
Hi arnelgp,
Thanks for the prompt help.
However, I am getting an error:
Syntax error in query expression 'where " " & TableA.[Long tail keyword] & " " Not (Like "* " & TableB.[short tail keyword] & " *")'
After I close the error message box, the word Not is highlighted.
What should I do to filter Table A by using Table B as filter? Any records in Table A that contains words in Table B should be removed in the final list. (please see attached image for more details).