How To Create A Keyword Search in Access 2013 🎓

[@ProgrammingMadeEZ]

Looking for DAILY content? Join us on my other channel “Coffee With Steve” for daily videos where we discuss Technology, Software Development, Politics, Culture, and many other things. Coffee With Steve: kzbin.info/door/eXAUvo5xxDY_b-lSknPC1A

[@xg2845]

Hi thank you for your tutorials. I just wnt to ask how to create a button that everytime you click increases the number? Thank you so much =)

[@Itsmefeddi]

searching this topic for weeks and nothing come across better than this keep the good work you are truely the best teacher

[@joto1218]

This is by far the best tutorial I have viewed on Access Database in searching forms with lots of option in building your SQL query.

[@abdullaaman3518]

This is the best tutorial video I have viewed ever about search forms. thank you sir.

[@Ha-Lion]

Not only it was comprehensive, you explain it clearly and step by step. THANK YOU,

[@appsusere2069]

I have to tell you that you have done an excellent job here by creating these videos. After these many years it's still useful to people who trying to know Access as it offers, I came here to learn to how to built query for a rather seemed to be a difficult calculation and now I am building an inventory system by myself. only thanks to you. The details and extra features that you explain on your videos are so useful and which can be useful in different senarios. Anyway meny thanks and you may get the best out of your life.

[@JeffersonHI]

Mahalo plenty, Steve! This lesson was *exactly* what I've been looking for. Your explanations were clear, concise, and thorough.

[@thegrapevine4897]

Just want to say a massive thank you for this incredible tutorial. I am a total novice at this and this was easy to follow and iv managed to create a brand new search database for my work colleagues to now search for information rapidly. Thanks very much for this. Brilliant and perfect.

[@ProgrammingMadeEZ]

I am so glad to hear you found this video helpful. Hopefully you find the rest of them equally helpful.

[@artsafari8157]

Thank you! Clear, concise, and thorough - this is hard combination to find but your video has all three.

[@emerson_mora]

Thanks, I started using Ms Access a few months ago and I find your videos really good. This one helped me refine my search form in my current DB project. Thanks a lot.

[@akwasisarpong241]

Man you are the Good Lecturer ever. man i love it. Not only this video. All your videos. You really knows the thing. Thanks so much. you've tought me very well. God bless you.

[@ElainePlourde]

THANK YOU! Been struggling with this months and watched other tutorials but this was the only one that finally worked out!

[@brendagutierrez2838]

This is the best search form tutorial on youtube. Thanks

[@tadgh123xx]

Thanks Steve your tutorials are amazingly clear and easy to follow but more than that your explainations make it understandable also, i really learn when i watch your tutorials as opposed to just being able to copy

[@glenntaylor2863]

This is a great video and I've implemented it with great results. I've enhanced it slightly by adding one more VBA line and that is returning focus to the keyword text box so I don't have to select the contents of this text box, hit delete and then Enter to get all the records or to enter a new search. "tion" returns all records with this sub-string and then just typing "national" returns all records with this new sub-string. It saves a lot of keystrokes and keeps my hands on the keyboard when I'm trying to search using different strings.

[@lordshin73]

It is a pleasure to listen to you share your knowledge! By far, one of the absolute best instructional/demo videos I have come across for MS Access. I subscribed.

[@antes562]

Hi, I learned a lot from your video...Thank you... You were the best to explain how to create this search button.

[@ScottHuffIndy]

Thanks for this easy-to-follow tutorial. I found it exceptionally helpful.

[@ricky-leeerickson8657]

Hi, thanks for the great video! Do you have a video outlining how to export the results from listboxes to an excel document? Thank you

[@c.p.aidamendozag.5520]

Hi Steve, I've been through most all of your videos and they have helped me a lot. Thanks For Your Time And the great Asset You made Available to Us.

[@ProgrammingMadeEZ]

I'm so glad to hear that!

[@keeley2798]

2017 and this amazing tutorial still works perfectly! One question for Mr Bishop - is it possible to make the same code search using more than one text box? I've managed to make five text boxes each with their own search button, but it would be so nice to have one button for all! Thankyou for the video Mr Bishop, you're a lifesaver!

[@kathysolheim9041]

I love this video! Perfect instruction! Is there a way to output the results of the filtered subform to Excel?

[@MrBummpr]

I have the same question/problem...I need to send the results of my Search to an Excel spreadsheet.

[@MikeRadoiu]

Your explanation is very clear and easy to follow. Thanks.

[@ProgrammingMadeEZ]

Thank you!

[@mariammalik5559]

Thanks so much. Should you treat a split form as a continuous form or a listbox?

[@kylemorrison5399]

Mr. Bishop, Would this key word search be able to be adjusted to allow you to search different tables all at the same time. If you are handling different parts of a project, and they are handled in different tables, would you be able to set up a search just like this but that will look through 3 or 4 tables? if so would you be able to help me with the coding that would allow that? thank you for your time and the AMAZING videos.

[@Qnikchen]

your videos are amazing, I feel very grateful to find you on youtube!! you are my favorite guy!!

[@ProgrammingMadeEZ]

Well thank you!

[@brainybooks6203]

Steve, who ARE you? You are doing such a great public service to we who are learning to work with Access. When I send you a question, you reply within half an hour AT THE MOST. For example, are you independently wealthy so that you don't need to have an actual paid job? Or maybe you're a Catholic monk or a Buddhist monk and this is your humble service to humanity. Please explain! Thx.

[@ProgrammingMadeEZ]

Hahah.. well I'm certainly not wealthy. I am a software developer for a small father/son company. I do these videos mostly on the weekend when I get a chance. I wish I could do it much more often but I have a family who wants my time too.

[@OOlasokan]

Steve, your voice is so assuring and you instructions very clear. I would like to show my appreciation. How can I donate a token to the great work you're doing?

[@miked979]

Great video. Thank you. Is there a way to search for multiple keywords at the same time? IE: "Elizabeth, John" and have results for Elizabeth or John show up on one query.

[@antonioaleixo1519]

Please Steve, keep doing these very good tutorial videos. Many Thanks

[@marcushilliard8857]

This is a GREAT tutorial video....how would you set up the form if you wanted to use check boxes as inputs (hard code options) to the search filed as well?

[@sonnicolabo3025]

Thanks Bishop easy to learn from your tutorial.

[@philipmcdonnell7168]

In 2018 this is still a valuable video. :)

[@Constance_R]

Exactly what I needed, it seems that Access gives you much more control over the forms if you don't start with the wizard.

[@ProgrammingMadeEZ]

Yes, I despise the wizards!

[@jimmyteddy219]

Thank you steve,i would like to know can i substitute the keyword search for a number search ?

[@ProgrammingMadeEZ]

+Uriel Ramirez It is available in 720p. You might need to click on the gear icon to change your resolution.

[@giftyazameti3308]

Great tutorial and well explained. What will you do if the input are integers or numeric?

[@janezvegan]

thank you very much for this video. It shows clearly how to start working with VBA in Access

[@ajborbzzz]

Liked and Subscribed. Very clear and concise tutorials

[@mariebrown3532]

I'm learning so much from your video tutorials! Thank you.

[@mediimaging2665]

Hi Steve. Many thanks. How to open the selected record on a form? Matthew

[@chessfighter54]

these is what i am looking for many years..

[@redhahamad6125]

You explain in such a way that anyone could understand thanks a lot. How can search records depends on two text fields and between two dates in a split form? Thanks in advance

[@sharmaneaurora6332]

Hi Sir, do you have a video for calculating running balance of inventory? Or generating Month-end summary reports for transactions?

[@AmyAstro]

Great video! So now I have my keyword form. Do you have a video on how I can select one of the search results and have it take me to another form?

[@somseiharath4586]

Thank you so much Great video. Could we links together between list box and continue form show the same result? and can be Form instead of continue forms that we can edit record?

[@ProgrammingMadeEZ]

Yes, just use the same SQL query for a the listbox and continuous form.

[@stevenwimberly6133]

I have my subform tied to a query that is pulling data from a table created by an Excel import. I tried to use the SQL from the query but it did not work. Is there another way I can achieve the same results with my configuration that are in this video? Or do I need to recreate my subform based on the table instead? Doing that would put a kink in the workflow I'm trying to achieve because I'm going to be importing Excel data each month and appending the table from which the query is based. Thank you for these wonderful instructional videos!

[@HarveyFrench]

In case you're not aware, once the form has a recordsource, you can use the ribbon>>Form Design>Add Existing tools button to select fields form the recordsource and drag them onto the form. Then use ribbon>>Form Arrange>>tabular to put the controls into a very useable grid layout.

[@ptzzycool]

This is a great video. Learned so much from it. I am just curious how I can write code if I wish to print the searched result especially using the continuous form? Thanks will wait to hear your response.

[@brittnifoster6950]

Can the where clause be for the entire table or does it have to be for specific column?

[@mostafaelhaj8391]

Very nice and clear video Thank you sir I have a question How can I display a report of the results in that area instead of the list box or the continuous form ?

[@joneil5765]

I could not find a better video than this! Good job A++++

[@20011332]

Thankyou very much. How about search by integer, the SQL how to change?

[@Jim-fk1wk]

Hello, can you do two search boxes? The second search box is dependent on the first search box? Thank you!

[@denisstpierre7140]

Very nicely done! Working on a db at the moment and this is very helpful 🙏

[@toneen5392]

Excellent! Answered many of my questions. Have another one. Can I use this type of search, but KEEP the results by appending the search to the end? Ultimately, I want to use the search results to create labels for only a few records in my table.

[@ILIILLLIIILL]

Could you tell me how did you change the line in the code editor please? at 11:18

[@ProgrammingMadeEZ]

+Finn Neraz I'm afraid I don't understand the question. I don't see and change.

[@ILIILLLIIILL]

+Programming Sorry for my poor english. 10:57 You split the long code line with enter key. how to do that? and it Automatically input "_" at the end of the line.

[@ILIILLLIIILL]

+Programming when I enter "_" it only cause me compile error.

[@johns8903]

Thanks Chris - I do appreciate your gift.

[@pronounceword]

I like your video very much. It's really great. I'll keep an eye on your channel. I am your fan and I will support you.

[@markanthonyalipao362]

Clear and the best tutorial ive learned a lot from you. Thank you!

[@zoranstojanovski8407]

Great video! Access Form has on navigation buttons little search field, but it is small. In your future video, can you show how to create text box with same functionality to search entire form and highlight what has found from VBA?

[@ProgrammingMadeEZ]

+Tom Carnaha I have found datasheets to be of no use at all. I would much rather make my forms look a very specific way for the user to help them with the flow of data. You can make the textbox widths as wide as you want. You can use Anchoring to allow the width of the textboxes to change with the size of the form so people can resize the window and the textboxes will resize with it.

[@khadimhussainmomin1315]

hi Steeve. i have created one tbl and in this table i have one field named 'HOUSE NO'. in this field i have suppose 4 members under house no 1. Now I wish to show house no 1 including all 4 member on one go. How can I search all 4 member by clicking just house no 1? please give me idea. i am using access 2007. Thanks

[@AdrianaBazz]

Thank you so much for your videos! They have been amazing. I was wondering if this code would work for numbers instead of words, meaning can I set it up to search for ID # instead of names?Thank you :D

[@steveaustin2586]

Hi there! Thanks for your help with this great video. Can you advise how I would search through a number field rather than a text field? Thank you!

[@ProgrammingMadeEZ]

If it's a number then you just check if the number is equal to the value in the field.

[@steveaustin2586]

even more simple than I expected. thank you!

[@ChrisSimmsJr]

Great tutorial! Do you have a video on selection a customer from the list which would then pull up their record to be edited?

[@ProgrammingMadeEZ]

Nothing that specific, but if you watch my basic series you'll learn all the tools on how to build what you want.

[@stansmith8822]

Steve, thank you so much! You are a fantastic instructor!

[@NoOverXplain]

Best tutorial of its kind

[@barrdennis2052]

Richard...I like the way you instruct. So many instruct, but do not tell one what property to place coding in and why. Also, can you present a single form with a one control search, where one can use LIKE operator with wildcards, to search on any field.

[@dottiearnold4988]

Hi - excellent tutorial! I have a question. I have created my search and it works perfectly. I was asked to have it search on full name. I'm assuming I need to add a concatenated field called FullName where the Last name and first name are merged and set the search criteria on that field. Is it possible to have it do all three? Search on first name only, last name only, or full name?

[@tupacmoche]

Steve as always your videos are clear, understandable and right to the point. Super job. In viewing this video, I was looking for an implementation that is built into Excel. What, I mean is if you enter a name of any other search string into the Excel search box the search scope the every column in every row in the spread sheet. Can this be implemented in Access and is there a video that demonstrates it?

[@doodelscitti]

At time frame 10:51, you somehow imported all your variables into the SELECT statement without having to type them out. How did you do that?

[@ProgrammingMadeEZ]

That came when earlier in the video we copied the already existing query at 9:53.

[@keithmortensen7075]

Hi Steve, I've been through most all of your videos and they have helped me a lot. I have a form where I created a keyword search of 1 table that, when clicking on a button, a user is prompted to enter a value and record(s) are returned data filling 8 text fields in my main form. What I want to do is use a returned value from a field in the main form for a 2nd keyword search of 2 other joined tables in a subform. Using the techniques you demonstrate in this video, I am able to use a "keyword button" search to validate the subform works. Here is the code for the button search of the main form Private Sub BtnSSN_SN_Click() Dim SQL As String SQL = "SELECT [Test_ KVDBA_kV_Matchpoint_Data].ID_GE_Serial_No, [Test_ KVDBA_kV_Matchpoint_Data].ID_BME_No, [Test_ KVDBA_kV_Matchpoint_Data].ID_Reg_Scan_1, " _ & "[Test_ KVDBA_kV_Matchpoint_Data].ID_Brd_Scan_1, [Test_ KVDBA_kV_Matchpoint_Data].ID_Brd_No1_SN_1, [Test_ KVDBA_kV_Matchpoint_Data].ID_Brd_Scan_2, " _ & "[Test_ KVDBA_kV_Matchpoint_Data].ID_Brd_No2_SN_1, Left([id_GE_Serial_No],8) AS Meter_SN_In " _ & "FROM [Test_ KVDBA_kV_Matchpoint_Data] " _ & "GROUP BY [Test_ KVDBA_kV_Matchpoint_Data].ID_GE_Serial_No, [Test_ KVDBA_kV_Matchpoint_Data].ID_BME_No, [Test_ KVDBA_kV_Matchpoint_Data].ID_Reg_Scan_1, " _ & "[Test_ KVDBA_kV_Matchpoint_Data].ID_Brd_Scan_1, [Test_ KVDBA_kV_Matchpoint_Data].ID_Brd_No1_SN_1, [Test_ KVDBA_kV_Matchpoint_Data].ID_Brd_Scan_2, " _ & "[Test_ KVDBA_kV_Matchpoint_Data].ID_Brd_No2_SN_1 " _ & "HAVING ((([Test_ KVDBA_kV_Matchpoint_Data].ID_Brd_No1_SN_1)=[Scan AMR Barcode])) OR ((([Test_ KVDBA_kV_Matchpoint_Data].ID_Brd_No2_SN_1)=[Scan AMR Barcode])) " ' [Form_Test_MP_SSN_Form].Form.RecordSource = SQL Me.Repaint Exit_BtnSSN_SN_Click: End Sub I want to use the value returned from field Meter_SN_IN as a keyword to query the subform. Below is the code for After Update Event. Private Sub TxtMeter_SN_IN_AfterUpdate() Dim SQL As String SQL = "SELECT KVDBA_TTST_SET.ID_SERIAL_NO, KVDBA_TTST_SET.TMSTMP_TST_START, KVDBA_TTST_SET.TMSTMP_TST_END, KVDBA_TTST_SET.ID_CAT_NO, KVDBA_TTST_SET.CD_CAL_PASS, " _ & "KVDBA_TTST_SET.CD_CAL_REASON1, KVDBA_TTST_SET.CD_CAL_REASON2, KVDBA_TTST_SET.CD_CAL_REASON3, KVDBA_TTST_SET.ID_STN_NO, KVDBA_tssn_testdata.ncc_card_barcode, " _ & "KVDBA_tssn_testdata.calibration_pass_fail_status, KVDBA_tssn_testdata.ssn_result_code, KVDBA_tssn_testdata.customer_serial_no, KVDBA_tssn_testdata.ge_serial_no " _ & "FROM KVDBA_TTST_SET INNER JOIN KVDBA_tssn_testdata ON KVDBA_TTST_SET.TMSTMP_TST_START = KVDBA_tssn_testdata.calibration_date " _ & "WHERE [ID_SERIAL_NO] = '" & Me.Meter_SN_IN & "' " _ & "GROUP BY KVDBA_TTST_SET.ID_SERIAL_NO, KVDBA_TTST_SET.TMSTMP_TST_START, KVDBA_TTST_SET.TMSTMP_TST_END, KVDBA_TTST_SET.ID_CAT_NO, KVDBA_TTST_SET.CD_CAL_PASS, " _ & "KVDBA_TTST_SET.CD_CAL_REASON1, KVDBA_TTST_SET.CD_CAL_REASON2, KVDBA_TTST_SET.CD_CAL_REASON3, KVDBA_TTST_SET.ID_STN_NO, KVDBA_tssn_testdata.ncc_card_barcode, " _ & "KVDBA_tssn_testdata.calibration_pass_fail_status, KVDBA_tssn_testdata.ssn_result_code, KVDBA_tssn_testdata.customer_serial_no, KVDBA_tssn_testdata.ge_serial_no " _ & "ORDER BY KVDBA_TTST_SET.TMSTMP_TST_START " _ Me.SubCalSSNList.Form.RecordSource = SQL Me.SubCalSSNList.Form.Requery End Sub Again, the main form works, and the subform also works. The problem is the subform does not run its query AfterUpdate of Meter_SN_IN Thanks, Keith

[@richlarrabee2073]

Can I use this to search for words in a Long text field? that is also in rich text format?

[@ReverendHogwash]

Another awesome tutorial, thanks for sharing! I have taken your comments regarding macros to heart and tried to convert the search macro in the northwinds db to VBA. I then attempted to use calls to access the functions, but that wasn't working. Is this method (continuous forms) you use in this video the best and/or easiest way to conduct searches without the use of macros, or is it possibly to utilize the converted macro with coding changes?

[@ProgrammingMadeEZ]

The code I demonstrate here obviously needs to be adjusted to fit your database. Column names, table names, etc all must be changed.

[@ReverendHogwash]

Indeed. I actually converted the macro from the NW db and am using it with quite a few adjustments. Really want to get away from all macros. Thanks again!

[@AirPunkt]

Great vid. It helps me a lot. Is there a way to use multiple keywords?

[@pilarangelicarodriguezcaba8199]

best video I found for this feature, thanks a lot! :)

[@glenisejohnson1531]

Thanks! I've used this video a few times. Would I be able to search by a date field as well with this syntax? I haven't been successful so far...

[@andresbustos3772]

Thanks, easier than this impossible, what a masterful explanation

[@jakebumm3227]

Very great video but i have a very important question. What if when i clicked the search button, i then want it to give me a parameter box and a drop down of the column headings im specifically trying to search in?

[@tellytelly6752]

Great info! How would I publish this table to an html page?

[@adrianeland87]

Really clear explanation. Learned a lot.

[@venkatavinod72]

Hi Steve your videos are excellent.Thank you for your help.

[@jamekahors]

You, dear sir, are a Rockstar!!

[@carsonrichards5552]

Do you have a tutorial on how to open up a customer's profile from the search form?

[@philr3630]

This was a very good video and I enjoyed following along. I got the search to work perfectly but when I brought in other fields within the subform they looked fine scrolling through before I did the search but after the search/enter each field other than the fields in the string return #Name? . Can you direct me to another video?

[@LearnAccessByCrystal]

excellent video tutorial to show how to implement search criteria whether it is for a form, listbox, or something else! Great job, Steve @ProgrammingMadeEZ -- So nice to see really good videos for Access! thank you ~ crystal

[@michaelfenwick9440]

This is a great tool. Can I make the selected contact a link to that record too?

[@ProgrammingMadeEZ]

Yes.

[@okeemfahie7554]

Great Video, Thank you for this tutorial! I do have a question however. What if you're creating an entry form and you create a search box to bring up a record. Once you're done with the record, you have a clear blank Search box and it should bring up a clean, empty form. However you hit the Search button on an empty Search text box and it brings up the first record. What code would you have to place into the Search button that brings up a clear form when ever the Search Text Box is empty?

[@alexanderhamilton1223]

Is it possible to use the list box to select a specific record to edit on a form?

[@Afrikan221]

That's so great. Exactly what I was looking for. Thanks for sharing.

[@Shorts-ek1qw]

I DO HAVE A QUESTION AND YOU SAID FEEL FREE. HOW TO DO MULTIPLE KEYWORD SEARCH. I SEARCH FOR "A,B,C,D" AND THE FORM WILL SHOW ME DETAILS OF THOSE 4 ITEMS AT THE SAME TIME. HOW TO DO THAT? THANK YOU SIR! YOU CREATE GOOD VIDEOS. OLRAYT.

[@craigsunderland6404]

I watched a video on the split function which 'could' perhaps be combined with a for each loop? which I figure might have something to do with this, but yes, I was just about to ask this question myself...

[@brittnifoster6950]

Great question. I am curious about this as well.

[@InfernalSpelll]

the query pulls from a table of information. and when updating information, would a newly ran search yield results for the updated table? or is the search essentially a snapshot of a query that was done at the time? i think i know the answer to this question but i wanted to make sure before proceeding. It'll be an updated search right?

[@walterpinkstonii8925]

First of All, Thank You for putting the video together. It is very helpful. I am running into a problem where some of my keywords are not pulling the information from the table in the search form. I recreated the search/form and still have the same problem. I recreated a basic search query and it works fine. Any assistance would be greatly appreciated.

[@akashtribhuvan8124]

Great, will start learning from beginning 👍 it's really hard to find best videos 😄

[@pegmolter3542]

This is fabulous! Please tell me where I can find more videos like this one. I've been looking all over for Access "tutorials," but they seem to be very rare. I'm working in Access 2016, but the code worked just fine, and I'm jonesin for more!

[@Nabi_25]

Thank you so much I’m making soft so fast now back then I was confused, thanks

[@tinafoster9702]

Great tutorial, but I am having some issues with Access not recognizing my table - would this apply to Access 2007 as well? When I create the select query attached to the subform and I then try to assign the fields to the appropriate textboxes, they do not "show up" when I try to select them in the Record Source drop-down if that makes any sense? Any help would be greatly appreciated - thanks!

[@tomcarnahan3898]

Do you ever try to use the datasheet view to do the same thing? I noticed that it doesn't seem like you have much control over the width of the columns or the names of the headers. Is there a trick to doing it with a datasheet?

[@Langlands07]

Great video - But how do you wrk things when you run out of Screen Estate ?- I have a few more fields that I want to add has my relationships are based on a many to many relationship but unfort you run out of space - Any ideas would be great! Tx Paul

[@ProgrammingMadeEZ]

For something like that, perhaps building a special form just for the fields you want to search by that is a popup off of this one. Also, you may want to reconsider doing all of the search capability from one screen. Perhaps you would want to add search functionality for individual forms.... like a search on your customers form.. a search on your inventory management form... etc. I don't know how your application is broken down, but it's good to not have one place that tries to do everything.

[@Langlands07]

Thanks for the reply! Sounds like a gd idea I'll have a bash at looking into that

[@muhammadasadkhan3466]

Hi I am looking for a tutorial, where I would be able to populate listbox with contents of a folder (xlsx, CSV files) and then clicking to import them. Hope you will help