How to create MULTI-FIELD SEARCH FORM in MS Access | Edcelle John Gulfan

This is a Multi-field search form which SEARCH RECORD WHILE TYPING.
If you find this video very helpful and useful,
PLEASE LIKE👍, SHARE AND SUBSCRIBE❤️
Downloadable Templates:
• Free Download Template
A cup of coffee is always welcome : www.paypal.com/paypalme/eduar...
OTHER CONTENTS:
How to customize buttons?: • How to Customize the C...
Beginner's guide for ms access: • MS Access STEP by STEP...
HIDE OR UNHIDE columns in datasheet view: • How to HIDE or UNHIDE ...
👍 Please Like comment and share to support this channel
kzbin.info...
KEYWORDS:
Multiple Keyword Search in ms access, multi-field dictionary, access search form multiple fields, search as you type in ms access combobox,
access search form multiple tables,
how to create a search form in ms access, search form in ms access 2016, how to create search box in ms access form, search button in ms access form, search record in ms access form, creating a search field in ms access form
create a search form in ms access, how to add search box in ms access form, how to create a search form in access database, how to create microsoft access search form, how to create advanced search (multi-field) form in ms access, how to search a record in ms access form
what is the search key in access, how to create a search form in access 2007
search box in ms access form, how to create a form to search records in access
create search form in ms access, search form in ms access database
search form in ms access date, search form in ms access data, search form in ms access definition, search form in microsoft access database, search form in ms access example, search form in ms access example database, search form in ms access example download, search form in ms access explain, search form in ms access edit, search form in ms access entry, search form in ms access events, search form in ms access form, search form in ms access formula
search form in ms access file, search form in ms access free download, search form in ms access function, search form in ms access for record, search form in ms access field
search form in ms access full, search form in ms access filter
ms access search for record in form, how to create a search textbox in access form
search form in ms access guide, how to create a keyword search in access,
MS Access keyword search by multiple fields,
Access VBA Keyword Search Function on multiple fields
Multiple Keyword search on one column, Multiple word search criteria in a query
Search box, Search tex, search button in ms access,
how to make a search box, how to make a running search box,
search field in access form, microsoft access auto search box,
Data Engineering, Data Science., ms access vba,
database, benefit for .net and access data., microsoft access toturing,
microsoft access tutorial, microsoft access tutorial for beginners,
software design tutorial, database design tutorial,
#microsoftaccess
#microsoftaccesstutorial
#mstutorial
#SearchForm

[@ursyten]

This is my favourite multi field search form tutorial! I come back to it again and again.

[@EdcelleJohnGulfan]

Thank you so much for watching

[@elija_ed_vann]

So simple and work greatly. ..love it 🥰😇

[@EdcelleJohnGulfan]

Thanks for watching Elijah.

[@retolop]

Thank you so much. Best regards Iraq - Baghdad

[@EdcelleJohnGulfan]

Thanks for watching.

[@mianyambao5845]

Sir! Thanks for sharing po. Ang laki ng naitulong nya sa mga data ko. Godbless you more po.

[@EdcelleJohnGulfan]

Welcome po.

[@FunnyHaHa23]

mao ni pinaka klaro ug pinka tibay na tutorial sa balat ng lupa salamat lodi.....

[@EdcelleJohnGulfan]

Salamat

[@El-Ge]

Maraming salamat, Po. Your videos on MS Access are very helpful for me.

[@EdcelleJohnGulfan]

Maraming salamat sa panonood

[@imstevemcqueen]

Excellent simple method. There are other videos showing same type of functionality, but with massive amounts of coding, which isn't optimal, like this technique is.

[@EdcelleJohnGulfan]

Thank you so much sir.

[@yawarabbas205]

very awesome video sir. thanks for valuable sharing.

[@EdcelleJohnGulfan]

Your welcome sir. Thanks for watching.

[@vinloivinloi]

Thank you very much! God Bless!

[@EdcelleJohnGulfan]

You are very welcome.

[@Waberduggi]

Thank you very much for the tutorial

[@EdcelleJohnGulfan]

Welcome Ruedi.👍

[@deepkumar3545]

Your video very helpful to us.

[@EdcelleJohnGulfan]

Thanks for watching Deep.

[@jeffreyalejaga707]

Well done Sir, thank you...learned a lot from you...salamat...

[@EdcelleJohnGulfan]

Maraming salamat din po.

[@subbiahvr5285]

very nice and very useful and simple thank u Dr VR SUBBIAH FROM INDIA

[@EdcelleJohnGulfan]

Thanks Doc. It's highly appreciated.

[@abdulhamidalhaddadi2255]

GREAT, I WILL TRY SOON

[@EdcelleJohnGulfan]

Thanks for watching Abdul.

[@krishiggins8917]

Thank you. This is incredibly helpful. All of your fields have data in them, which makes the search very simple. Some of my records have blank fields. Do you have a video that explains how to handle a search when some fields have data and some fields are blank?

[@zoomingby]

Holy crap. I never thought to use a list box that way!!

[@EdcelleJohnGulfan]

Thanks for watching.

[@waymsa]

Great job

[@EdcelleJohnGulfan]

Thank you so much.

[@sarbjit5734]

Brilliant! Have incorporated it into my database. Going to see if I can add a second table and search across both tables at the same time. Is this something you might have done already?

[@sceptersax]

Awesome

[@EdcelleJohnGulfan]

Thanks for watching

[@itpknw4404]

Very good video, thank you. Question: do you have a video showing how to use multiple criteria on the same field? so if i have a table with 20,000 records (and I do), I have a 'caption' field where it contains name, city, and other fields. i would like to do a search on the same field where first it searches by one specific city and then filter that search by one specific last name. So a filtered search on a filtered search from a form. You have anything like that? thank you!

[@excel_master_habib]

Thanks

[@EdcelleJohnGulfan]

You are welcome

[@michaldycka6751]

Nicely done, understandable even for rookies! ;)

[@EdcelleJohnGulfan]

Thanks for watching.

[@Modi626]

شكرًا

[@EdcelleJohnGulfan]

Hi. Thank you so much.

[@mariapavone9962]

Hello. Thank you for your video. It is great. I was wondering how you can enable the list box results to be copied pasted outside of Access. I will be taking information from the list box and working with it elsewhere, and would like to be able to copy an entire line and paste in excel for example. Is there something in the properties to allow this function? Or can you write code in the data or event tab of the properties somewhere?

[@EdcelleJohnGulfan]

The data shown in the listbox is in the Query. You can export the query to excel with the data that being shown in the listbox.

[@mikpu]

Hello Sir! This is such a wonderful Video! Much appreciated! 🙏 🙏 🙏 There's a question I want to ask: Would it be possible to make it so that when I click on a specific record shown in the ListResults box, a different form containing more details about that particular book pops up???

[@EdcelleJohnGulfan]

Yes, it's possible.

[@EdcelleJohnGulfan]

Click specific data t open specific records in different form.

[@jaysonwonder6667]

I like the video. Perhaps I am missing something but why the duplicate text boxes (SearchBox & SearchText), can this not be achieved with just the one main SearchBox? What benefit does the hidden SearchText provide? Thank you and appreciate your time.

[@EdcelleJohnGulfan]

Every textbox has a purpose. Try to make in actual using only 1 textbox and you will know. Thank you for watching.

[@jaysonwonder6667]

@@EdcelleJohnGulfan I understand. SO MS Access cannot build and run a query on "the fly"? Would you explain it please?

[@Amine-is6yq]

@@jaysonwonder6667 i think cause it's a list and you should extract only text to use it in the query

[@NFAtoys]

As yet I haven’t seen a reasonable answer. Setting a second text box equal to the user input text box, seems redundant and unnecessary. Simply change the query to reference the user input text box to get the search string. One thing to note, this won’t work on fields that contain non text data, like dates, currency, check boxes, etc.

[@ahsanhabib9870]

Very informative sir , can you make a video stock in and out automatically using ms access? Waiting for your new video…..! Thanks 🙏

[@EdcelleJohnGulfan]

Thank sir.

[@imstevemcqueen]

Set initial stock level, then query [initial stock level] minus (-) [number of items sold] (count) . Aggregate query.

[@ahsanhabib9870]

Tanks a lot sir

[@twixxx0]

Thank you for this great video! Does anyone have any advice for making an open record button? I’ve already made a Single Record form that pulls all the information from the table and shows one customer record at a time, and I would like to jump from the record being found in search to automatically opening the single record form view.

[@EdcelleJohnGulfan]

Open specific record: kzbin.info/www/bejne/i6CYoYmVrLZnqcU

[@EdcelleJohnGulfan]

Try this also: kzbin.info/www/bejne/d4G0h6Zpe9WYmLs

[@ukko2k]

Hello - - thanks for the tutorial - excellent !! One question - when i go to spilt the database it, the "editable" local copy works, when i share it to my users - the search functions does not work, there are no errors appearing, is this a VBA issue? Thanks in advance,

[@EdcelleJohnGulfan]

Just check the syntax compatibility. Because sometimes you need to change the * to %.

[@ukko2k]

Hi - thanks for that, i tried that and if changed to % the search field stops working in the local as well as no function in the split copy.. @@EdcelleJohnGulfan

[@BanditFX7]

Hello Mister Gulfan, it's very useful tips How to display a dialog window which proposes to automatically add a missing element of the search form in the table? To make data entry management more efficient.

[@EdcelleJohnGulfan]

Kindly have a sample Sir Rovetto. By the way, thanks for watching.

[@morganeconnan3520]

Hello tank you so much for your explanation I have a question though : do you know how to make possible to from a click on a result we can get a form open through the AutoNumber ? I mean : if a I have customer1 with this search as a result and I have a form (lets call it form1) which sum up all my infos about this customer and with a click (or button) on the search form I can get the form1 open at the right customer ?

[@EdcelleJohnGulfan]

Same with this link.kzbin.info/www/bejne/ZorcZ3qQmclkbbc. This method is open specific record but using list box. I Will create tutorial about this.

[@EdcelleJohnGulfan]

Thanks for the question

[@larrywelch9359]

Do you have or know of any available course that I might purchase pertaining to: MS Access, VBA Code, creating a function that will set the ActiveForm and ActiveControl (of function) that can be used on the current open form.

[@EdcelleJohnGulfan]

No need to buy. A lot in KZbin.

[@SimplyAmazing247]

Hi There! Is it possible to do this in online database?? I am trying to convert existing db to online db but I have a multivalue field with lots of linked items. The developer is saying it can’t be done.

[@EdcelleJohnGulfan]

You have to publish it in asp.net but there's a lot of changes.

[@kennethjeffuy]

Kuya. Ok yung content mo. Sana mapapalakasan mo ang audio tapos matatangal ang background noise

[@EdcelleJohnGulfan]

Next time po. Yan po problem ko. Salamat sa panonod.

[@mikeygrey9855]

Hi. I've followed your tutorial but I've added this form onto my navigation form. Now it asks for the parameter "Forms!Formname!SearchText How do I change the vba code to allow this on my navigation form. It works as a standalone form but not as a subform on my navigation form

[@EdcelleJohnGulfan]

This is the solution. kzbin.info/www/bejne/gnKad6GqntCsqZI

[@Skyfinder007]

I tried it, but after every letter I enter in the searchbox my cursor move to the next field. I used the event On Change as you did. Do you have a solution?

[@EdcelleJohnGulfan]

Use .SETFOCUS

[@Skyfinder007]

@@EdcelleJohnGulfan that for answering my question. I already tried, it just highlight the letter I typed so if I type another letter it will replace the previous one. After the setfocus I need an instruction that will put the cursor at the end of the textbox. I believe there is something but cannot find it.

[@sanjaykanojia3336]

Hi Gulfam, when load my navigation form query give me error because textbox keeps blank at the time of loading..

[@EdcelleJohnGulfan]

Can you paste your code here?

[@Amine-is6yq]

Hello , how please you create a beautifull dashboard like yours

[@EdcelleJohnGulfan]

Yes sure.

[@tuamaleos4519]

Hai, Can we get an example of the MS Access this file ? Thanks.

[@EdcelleJohnGulfan]

Yes.

[@EdcelleJohnGulfan]

Send me your email.

[@DeViL87101]

i have problem for function vba. i can't find Me.Searchtext and Me.Searchbox and why ? Please, tell me how to fix it or solution. thank you.

[@EdcelleJohnGulfan]

Just insert a text box in the form and name it as searchtext and searchbox

[@DeViL87101]

@@EdcelleJohnGulfan same problem.

[@eh4010]

Sir pde b maging clickable un result. Sample if description nkhide n dun s result at pg click ko lalabas boung information

[@EdcelleJohnGulfan]

Pwede po. Properties setting lang yan.

[@arumugamramu645]

How to link one text box to another text box in ms access. Pls help me.

[@EdcelleJohnGulfan]

Kindly expound what you want?

[@mahammadkamruddin2416]

Retrieve data based on user id details ? I have seen many but not found any solution for that can you have solution for it please explain for us, 🤔

[@EdcelleJohnGulfan]

Why do you need to retrieve? Is it lost? Or something corrupted?

[@deepkumar3545]

Want search listbox value export to pdf or excel

[@EdcelleJohnGulfan]

We will create that soon. Maybe you can get idea from this video. kzbin.info/www/bejne/d4G0h6Zpe9WYmLs

[@runejors]

How do i send the results to a report for print

[@EdcelleJohnGulfan]

I have video on that for upload soon.

[@runejors]

Brilliant

[@EdcelleJohnGulfan]

Try this kzbin.info/www/bejne/d4G0h6Zpe9WYmLs

[@adriansolo3849]

hi sir good pm, pde po pagawan kung paano maiiprint or magiging report yung na filter . thank you..

[@EdcelleJohnGulfan]

Ok po. Salamat sa suggestion.

[@rogeljragas474]

Ng eenter parameter po kpg gagamitin q navigation control kpg open q ung list form.

[@EdcelleJohnGulfan]

Simple lang po yan. Delete your parameter, me a new one using build expression yata yan. Yang nasa itaas.

[@deepkumar3545]

How to export list box data in pdf

[@EdcelleJohnGulfan]

I will create video soon

[@nesnag143]

Your video, sample database and VBA are good but the video is blurred.

[@EdcelleJohnGulfan]

You can adjust the quality of resolution. Click the setting icon on KZbin video and choose 720 or Up to view clearly.

[@nesnag143]

@@EdcelleJohnGulfan Thank you! I've got it.

[@amitbhardwaj8258]

how to remove enter parameter value From!List Equipment!SearchText

[@EdcelleJohnGulfan]

Open your query and delete the creteria.

[@rotethongvanit]

explanation not quite clear.