Hi All. First of all, I'm new to this forum and not much fluent in MS Access.
This is my issue. I have created an Access form to search for data that I have entered in the Access table. I have done it using a Macro builder. It works for a single word search. But I want to search using multiple keywords. It can search using multiple values in a single text box. But,
My issue is, it searches for all the words in the Access table that matches the multiple inputs. But I want to search and get records that contain the multiple search values I have searched for.
Eg:- Table contains These Names
I want to search for 'Sanath Perera'.
Then I only want the results containing all the values I searched.
The search results that I want is,
'Sanath Anton Perera'
'Julian Sanath Perera'
Hope you got the question. And I would like to post the code that I used. I would like to thank @jdraw and @Brianwarnock for their amazing work.
Code is attached.
This is my issue. I have created an Access form to search for data that I have entered in the Access table. I have done it using a Macro builder. It works for a single word search. But I want to search using multiple keywords. It can search using multiple values in a single text box. But,
My issue is, it searches for all the words in the Access table that matches the multiple inputs. But I want to search and get records that contain the multiple search values I have searched for.
Eg:- Table contains These Names
Sanath Anton Perera |
Sanath Kumara |
Julian Sanath Perera |
I want to search for 'Sanath Perera'.
Then I only want the results containing all the values I searched.
The search results that I want is,
'Sanath Anton Perera'
'Julian Sanath Perera'
Hope you got the question. And I would like to post the code that I used. I would like to thank @jdraw and @Brianwarnock for their amazing work.
Code is attached.
Attachments
Last edited: