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.
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.
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
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
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?
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.
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?
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
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
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?
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
@@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
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
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.
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.
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.
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 .
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😢
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.
Thanks.
That's highly appreciated.
Thanks, that's why mine didn't work
Wonderful examples and well explained
Thank you! 😃
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.
Limit the record to be displayed?
@@EdcelleJohnGulfan
Like filters in excel select more one columns
Display records by ID where the items in column one like Apple and city in column 2 London
Big Like as usual
Thank you
Thanks finally I could learn it. I saw many other videos and was not working
Thanks for watching my video Sally.
Excellent Work
Thanks for watching
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.
Try to change the wild card criteria.
Instead of using "%" try the "*".
Sample: Me.filter="[ItemCode] like '*" & SearchText & "%'"
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!!
Thank you for this bro im learning a lot!
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
Can create a list box to identify items you want to move to a different table?
Yes and associated with append query.
Thank you! I have sent your email, and if you get a chance to look at much appreciate it.
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
Use Append query.
thank you very much@@EdcelleJohnGulfan
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?
Yes. I have a video about opening specific report or record in a form.
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.
Hi. Have you tried using Query? Combining Multiple tables and apply this method.
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?
Very helpful 👏👏
Glad it was helpful!
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
Hello bro, thank you so much for sharing your knowledge !!!
Thanks for watching also Dunkel.
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
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
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
@@EdcelleJohnGulfan thank u sir. Laking tulong po ung mga ginawa mo 🙏🙏🙏🙏
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?
You can contact me through my email. eduardogulfan@gmail.com
Thank you very much for the video
You are welcome
Nice trick. Any idea why the asterisk search character did not work? I recall I had a similar issue at some point
SQL Syntax compatibility.
sir... how to open a report specifically from the searchtext results? thanks very much...
Try this.
th-cam.com/video/APQVs3FpebY/w-d-xo.html
thank you so much sir
Welcome sir.
Great job but you forgot VBA in Close button
Owwwwss. Just type only Docmd.close
Thanks
@@EdcelleJohnGulfan I tried by my self
Me.closebutton
I got error
I will correct it now
Appreciate
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?
Meron akong book pero 2003 version.
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
I mean city in textbox2*
Show here your code. I will check.
@@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
Hi, Why are there no messages to see the search result. thank you
Good day sir.. Refering to the above.. Once a search is done, can we double click to open it to a form?
Yes Selvaraj.
Check this link th-cam.com/video/Uo5pV_wQ4sc/w-d-xo.html
@@EdcelleJohnGulfan thank you again sir.. Thank you for sharing your knowledge.. God bless you
Welcome
@@EdcelleJohnGulfan hi.. Can we have the backend stored in 1 drive
can you create student registration system?
Yes sure
Subscribed bro
Thanks for subscribing this channel. It's highly appreciated.
Hi may i know why my front access increased its memory every time i open it and closed? Thanks very good job sir
Increase the memory or increase the file size?
Increase file size po sir. Pano po gagawin pag ganito. Thank u
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
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.
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.
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.
I will create a video about this soon.
if Can't find , can show popup ?
No records found?
Morning sir.. How many fields can we search
As much as you want.
@@EdcelleJohnGulfan Thank you sir
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
.
👍 excellent work.
Can you please share exercise file(products table)
Thanks
Yes sure. I will post the link in the description below tomorrow.
Here's the link
drive.google.com/file/d/1VGz4UwHh0SV0Mv4akcAekAn8w020tkrD/view?usp=drivesdk
Sir can you show how to add date into job order.. Example 2207xxxx
go to format and place this. ddmmyyyy
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😢
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.
Sir ano po pde gawin para di ma edit yung data dun mismo sa form view? Salamat po sana ma notice
May specific user lang na pwede maka.edit?
Try this.
th-cam.com/play/PLxBRM3hoV3nPnbZUiW92Kgw-gPCeFlp48.html
I'm getting no results when I search..
Check your sql syntax or simply change * to %
Cord not working properly
It is not working even after putting %
Try to click compact and repair database.
I tried but no change
8
Thanks for watching Selvaraj.
Hi sir.. When we do a search on any field it works but it doesn't when the field is ID... Why?
Is ID included in your criteria?
@@EdcelleJohnGulfan yes sir
Yes sir it's included