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

[@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.

[@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?

[@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

[@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!!

[@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

[@mrvictor2010]

Big Like as usual

[@EdcelleJohnGulfan]

Thank you

[@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

[@Jaydayvid]

Thank you for this bro im learning a lot!

[@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.

[@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.

[@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.

[@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 & "%'"

[@bossoftwareandtechnologies8731]

Excellent Work

[@EdcelleJohnGulfan]

Thanks for watching

[@darkphet]

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

[@EdcelleJohnGulfan]

Thanks for watching also Dunkel.

[@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]

[@AungAung-mi6qb]

Thank you very much for the video

[@EdcelleJohnGulfan]

You are welcome

[@marieklamo2383]

thank you so much sir

[@EdcelleJohnGulfan]

Welcome sir.

[@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.

[@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

[@santrehNgoding]

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

[@EdcelleJohnGulfan]

Try this.
th-cam.com/video/APQVs3FpebY/w-d-xo.html

[@Abdullah_Alhathloul]

Very helpful 👏👏

[@EdcelleJohnGulfan]

Glad it was helpful!

[@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

[@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 th-cam.com/video/Uo5pV_wQ4sc/w-d-xo.html

[@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

[@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

[@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 🙏🙏🙏🙏

[@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.

[@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

[@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.

[@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

[@mtop3147]

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

[@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

[@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.

[@ethiovox]

Subscribed bro

[@EdcelleJohnGulfan]

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

[@legaspijonel2032]

can you create student registration system?

[@EdcelleJohnGulfan]

Yes sure

[@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.

[@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
.

[@beerlomo3606]

if Can't find , can show popup ?

[@EdcelleJohnGulfan]

No records found?

[@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.
th-cam.com/play/PLxBRM3hoV3nPnbZUiW92Kgw-gPCeFlp48.html

[@selvarajandiappa3143]

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

[@EdcelleJohnGulfan]

go to format and place this. ddmmyyyy

[@sudathhsbc]

Cord not working properly

[@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