How to Create Multi-field Search Form in Ms Access using Continuous Form. | Edcelle John Gulfan

This video will show you on how to create a multi field search form in Microsoft access with a minimal VBA CODE.
DOWNLOAD THROUGH LINK BELOW👇
drive.google.com/file/d/1VGz4...
A cup of coffee is always welcome : www.paypal.com/paypalme/eduar...
👍 Please Like comment and share to support this channel
kzbin.info...
OTHE RELATED CONTENTS
1. Search as you Type - List box
• How to create MULTI-FI...
2. Search as you Type - Datasheet
• SEARCHING WHILE TYPING...
KEYWORDS:
How to create SEARCH FORM in Microsoft Access, multi-field dictionary, Microsoft access 365 tutoring,
search form in ms access, 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
microsoft access toturing,
microsoft access tutorial,
microsoft access tutorial for beginners,
software design tutorial,
database design tutorial,
Multiple Keyword Search in ms access,
access search form multiple fields, combobox,
access search form multiple tables,
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,
search field in access form,
microsoft access auto search box,
Data Engineering,
Data Science.
ms access vba,
database,
#microsoftaccess
#microsoftaccesstutorial
#mstutorial

[@Jaydayvid]

Thank you for this bro im learning a lot!

[@Jojosmith342]

For those who had the issue with search, I replace the % with wildcard * as Edcelle's instruction below, it works great. Thanks a lot Edcelle for your valuable tutorial. Thumbs up for another wonderful lesson.

[@EdcelleJohnGulfan]

Thanks. That's highly appreciated.

[@erw1nk779]

Thanks, that's why mine didn't work

[@kinganthonyx]

Wonderful examples and well explained

[@EdcelleJohnGulfan]

Thank you! 😃

[@Adorable.Princess]

Thanks finally I could learn it. I saw many other videos and was not working

[@EdcelleJohnGulfan]

Thanks for watching my video Sally.

[@darkphet]

Hello bro, thank you so much for sharing your knowledge !!!

[@EdcelleJohnGulfan]

Thanks for watching also Dunkel.

[@mrvictor2010]

Big Like as usual

[@EdcelleJohnGulfan]

Thank you

[@bossoftwareandtechnologies8731]

Excellent Work

[@EdcelleJohnGulfan]

Thanks for watching

[@AungAung-mi6qb]

Thank you very much for the video

[@EdcelleJohnGulfan]

You are welcome

[@Abdullah_Alhathloul]

Very helpful 👏👏

[@EdcelleJohnGulfan]

Glad it was helpful!

[@marieklamo2383]

thank you so much sir

[@EdcelleJohnGulfan]

Welcome sir.

[@ethiovox]

Subscribed bro

[@EdcelleJohnGulfan]

Thanks for subscribing this channel. It's highly appreciated.

[@dreamsmol2362]

Hi, How to filter multiple items like if we put in the search box Rock, Tom. It should show both the records. Please help... Thanks!!

[@Michiworkstechnologies]

Your teachings are awesome sir.I have learnt alot. Thanks for sharing your knowledge. Suppose I want to inbox you how will i get you?

[@EdcelleJohnGulfan]

You can contact me through my email. [e-mail]

[@ryanm.8282]

Na-apply ko din to Boss Edcelle, nagiimprove na dahan dahan ung database ko salamat ulit!!🖐😄 BTW meron ka bang online book/guide na mrrecommend pra mapag aralan at possible matutunan ung mga VBA codes kht tulad ko na di nmn computer base ang natapos?

[@EdcelleJohnGulfan]

Meron akong book pero 2003 version.

[@richtercastanares740]

Sir good day. Thank you for this tutorial videos. it helps me a lot. Sir I created ad multi-field search form using the union query. I want to open the specific record in a form but the problem is it will open all the records with the same ID. how can i change the numbering in ID field so that it will no longer duplicate?

[@selvarajandiappa3143]

Sir.. On the above everything works fine when name, address but when phone number, the first search works fine the second search on phone number does not work.. So I have to exit and open again the the number search works

[@jonathanlosito7718]

Hi Sir, do you have a sample code if I got multiple tables. Everything is working fine by the way except for multiple tables. Appreciate your feedback on this matter.

[@EdcelleJohnGulfan]

Hi. Have you tried using Query? Combining Multiple tables and apply this method.

[@yousseff8990]

Many Thanks for the explanation and clarification, but please clarify if we want to limit the search in a column by combo box or check box.

[@EdcelleJohnGulfan]

Limit the record to be displayed?

[@yousseff8990]

@@EdcelleJohnGulfan Like filters in excel select more one columns

[@yousseff8990]

Display records by ID where the items in column one like Apple and city in column 2 London

[@joemilan1301]

PLEASE SIR, MAY I HAVE GET SAMPLE MS ACCESS VBA CODES FOR CREATING TWO CBO WITH SEARCH TEXT WHERE ONE CBO IS FOR MULTIPLE TABLES SELECTING AND OTHER CBO IS MULTIPLE COLUMNS OR FIELD FOR AUTO SEARCH WITH SEARCH BOX BY HELPING THE SEARCHING TERM FOR QUERY TO DISPLAYS OTHER FIELD TEXT BOXES. THANK YOU

[@iaonibutinatirintetaake1229]

Thank you, Can you help with developing a tracking file system, I am developing a tracking file system and very confusing. I have three table including File Table, Letter Table and Letter Detail Table but very complicated for me given that one file have many letter to keep and the letter where also circulated using the allocated file. Can you help please

[@mariano-cucinotta]

Hi thanks for the file. I encounter the following problem: I copy the code with the related buttons and text box, but on your file it works and in my database it does not. Are there any special settings to set in the database? I can't understand why if I import my table from your database and change the data source and rename the fields it works, but in mi database the same settings doesn't work.

[@EdcelleJohnGulfan]

Try to change the wild card criteria. Instead of using "%" try the "*". Sample: Me.filter="[ItemCode] like '*" & SearchText & "%'"

[@YvesAustin]

Nice trick. Any idea why the asterisk search character did not work? I recall I had a similar issue at some point

[@EdcelleJohnGulfan]

SQL Syntax compatibility.

[@mloucel7]

Hello.. Let's say you want to open another form based on a record you found while searching, using a button [Open This Record] is that possible? will it work with something like docmd.openform ? or how will you do it?

[@EdcelleJohnGulfan]

Yes. I have a video about opening specific report or record in a form.

[@matorwmasen]

👍 excellent work. Can you please share exercise file(products table) Thanks

[@EdcelleJohnGulfan]

Yes sure. I will post the link in the description below tomorrow.

[@EdcelleJohnGulfan]

Here's the link drive.google.com/file/d/1VGz4UwHh0SV0Mv4akcAekAn8w020tkrD/view?usp=drivesdk

[@mtop3147]

Hi, Why are there no messages to see the search result. thank you

[@stephenbeswick2163]

Good morning I have been eating all your access database video the are grate to learn with. I have a database. My customer from is one colour we enter names and address etc, when editing this form can you change the colour of the form whilst entering the customers Infomation to tel my users they are in edit mode can you help me with problem I look forward to hearing from you grate video many thanks steve beswick.

[@EdcelleJohnGulfan]

You can add another button ( Switch to Edit Mode) Let's say the name of the button is EditBtn Private Sub EditBtn_Click() Me.detail.BackColor = vbgreen 'if green End Sub.

[@EdcelleJohnGulfan]

I will create a video about this soon.

[@sditihsanalfara]

Hallo, Sir. Do you have any solutions, if i fill a field on a form, and the value will be store at a field on many tables, please. thank you for your feedback

[@EdcelleJohnGulfan]

Use Append query.

[@sditihsanalfara]

thank you very much@@EdcelleJohnGulfan

[@aamalmarzouqi]

If I want to add tow or three text box and for each box different search Like if i saperate price in textBox1 And search of city in textBox1 ?? I tried but it's work in 1 box only

[@aamalmarzouqi]

I mean city in textbox2*

[@EdcelleJohnGulfan]

Show here your code. I will check.

[@aamalmarzouqi]

@@EdcelleJohnGulfan i did two way Me.Filter = " [IDB_LICENSE_NO] like '*" & Searchtext & "*' or [Hscode] like '*" & SearchText2 & "*'" in this code i have to type in both Searchbox to get filter 2- Me.Filter = " [IDB_LICENSE_NO] like '*" & Searchtext & "*'" me.filter = " [Hscode] like '*" & SearchText2 & "*'" in this code only the second is work

[@aamalmarzouqi]

Great job but you forgot VBA in Close button

[@EdcelleJohnGulfan]

Owwwwss. Just type only Docmd.close Thanks

[@aamalmarzouqi]

@@EdcelleJohnGulfan I tried by my self Me.closebutton I got error I will correct it now Appreciate

[@santrehNgoding]

sir... how to open a report specifically from the searchtext results? thanks very much...

[@EdcelleJohnGulfan]

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

[@thushara691]

Can create a list box to identify items you want to move to a different table?

[@EdcelleJohnGulfan]

Yes and associated with append query.

[@thushara691]

Thank you! I have sent your email, and if you get a chance to look at much appreciate it.

[@selvarajandiappa3143]

Good day sir.. Refering to the above.. Once a search is done, can we double click to open it to a form?

[@EdcelleJohnGulfan]

Yes Selvaraj. Check this link kzbin.info/www/bejne/i6CYoYmVrLZnqcU

[@selvarajandiappa3143]

@@EdcelleJohnGulfan thank you again sir.. Thank you for sharing your knowledge.. God bless you

[@EdcelleJohnGulfan]

Welcome

[@selvarajandiappa3143]

@@EdcelleJohnGulfan hi.. Can we have the backend stored in 1 drive

[@AbdulqadeerMohammed]

Good day sir I Saw your video on how to create a text animation in a form Microsoft access please sir the video is not in zoom I'm not seeying the cords correctly thanks very much I'm wetting Sir I'm ABDULKADIR from Gombe, Nigeria

[@EdcelleJohnGulfan]

Hi sir thanks for watching. If the resolution of your screen is blurred, kindly adjust it to higher resolution for better view experience. In your screen during playing the video, click the Gear Icon and choose the resolution.

[@diandhie]

Hallo sir, is possible to make a form from many queries? I have 12 queries and dont know how to make it show in 1 form😅and fill it in every different tables😢

[@EdcelleJohnGulfan]

Yes, you can. Either you join it together to make it one query or else create as 12 subforms. Make sure the 12 queries have primary key.

[@legaspijonel2032]

can you create student registration system?

[@EdcelleJohnGulfan]

Yes sure

[@babyboss6047]

Hi may i know why my front access increased its memory every time i open it and closed? Thanks very good job sir

[@EdcelleJohnGulfan]

Increase the memory or increase the file size?

[@babyboss6047]

Increase file size po sir. Pano po gagawin pag ganito. Thank u

[@beerlomo3606]

if Can't find , can show popup ?

[@EdcelleJohnGulfan]

No records found?

[@selvarajandiappa3143]

Sir can you show how to add date into job order.. Example 2207xxxx

[@EdcelleJohnGulfan]

go to format and place this. ddmmyyyy

[@babyboss6047]

Sir good afternoon po. Pano po mag disable ng editing sa mga list tsaka sa pag disable ng pagdagdag ng record sa continous form. Thank u

[@EdcelleJohnGulfan]

Hi sir good afternoon! Sa Form Property hanapin mo ang ALLOW EDIT at e-set mo to No. ALLOW ADDITION din set to No. Salamat

[@babyboss6047]

@@EdcelleJohnGulfan thank u sir. Laking tulong po ung mga ginawa mo 🙏🙏🙏🙏

[@selvarajandiappa3143]

Morning sir.. How many fields can we search

[@EdcelleJohnGulfan]

As much as you want.

[@selvarajandiappa3143]

@@EdcelleJohnGulfan Thank you sir

[@selvarajandiappa3143]

Sir..need another help.I am using 2 different monitors for Microsoft access.both the monitors don't have the same page size. One fit the screen and the other becomes bigger.. What can do the have the same page size .

[@cherdarl884]

Sir ano po pde gawin para di ma edit yung data dun mismo sa form view? Salamat po sana ma notice

[@EdcelleJohnGulfan]

May specific user lang na pwede maka.edit?

[@EdcelleJohnGulfan]

Try this. kzbin.info/aero/PLxBRM3hoV3nPnbZUiW92Kgw-gPCeFlp48

[@andye9341]

I'm getting no results when I search..

[@EdcelleJohnGulfan]

Check your sql syntax or simply change * to %

[@idlirbekteshi5648]

It is not working even after putting %

[@EdcelleJohnGulfan]

Try to click compact and repair database.

[@idlirbekteshi5648]

I tried but no change

[@selvarajandiappa3143]

8

[@EdcelleJohnGulfan]

Thanks for watching Selvaraj.

[@selvarajandiappa3143]

Hi sir.. When we do a search on any field it works but it doesn't when the field is ID... Why?

[@EdcelleJohnGulfan]

Is ID included in your criteria?

[@selvarajandiappa3143]

@@EdcelleJohnGulfan yes sir

[@selvarajandiappa3143]

Yes sir it's included