Hi, I need some help, I would be eternally greatful for any kind person out there to give me any advice.
I've created a database for the youth centre. It stores applications for funding. I have the table "tbl:Applications". And in that table there is a Notes field. I want to be able to do a search to bring up a list of all records containing certain words in the notes field. The thing is, I'm not sure on how to do this. I'm pretty sure the solution is either in an SQL query, or doing SQL from VBA.
I can get it to search for a specified word - for example if I want to search for all records containing the word "music", I have this SQL:
- SELECT *
-
FROM [Tbl:Applications]
-
WHERE ((([Tbl:Applications].Application_Name) Like "*music*"));
And that works fine. But I want it to search for a variable. One time I might want it to search for "music", next I might want it to search for "art", or I might want it to search for "Young Mums Equipment" (so more than one word). I just want to know how to achieve this. In an access query you can have [insert text] which will bring up an input box labelled "insert text" and what you tye in that it will search for, BUT it will only search for exact matches, unless you type asterisks around your search text. Is there any way to automatically put asterisks around the search criteria in the SQL code to make it do a containing text search, or is there something to do in VBA to do this? I need some help and I'm not an expert, but I need to get this working.