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,
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
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.
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.
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.
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?
will you please guide me as you teach in your vlog search with codes .I have problem while conditional searching .I have made a form where searching is on Service No .I want to search service No with condition like "and" against billing month. Guide ??
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 ?
Same with this link.ua-cam.com/video/0Yy6GZdd17U/v-deo.html. This method is open specific record but using list box. I Will create tutorial about this.
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.
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?
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
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?
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!
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.
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.
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 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.
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???
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.
This is my favourite multi field search form tutorial! I come back to it again and again.
Thank you so much for watching
mao ni pinaka klaro ug pinka tibay na tutorial sa balat ng lupa salamat lodi.....
Salamat
Thank you so much.
Best regards
Iraq - Baghdad
Thanks for watching.
5:55 I don't know why it doesn't work?
Having trouble with creating the criteria? Try to Change the * to %.
@@EdcelleJohnGulfan SearchBox on change event doesn't work?
@@EdcelleJohnGulfan Thank you
Sir! Thanks for sharing po. Ang laki ng naitulong nya sa mga data ko. Godbless you more po.
Welcome po.
So simple and work greatly. ..love it 🥰😇
Thanks for watching Elijah.
Maraming salamat, Po. Your videos on MS Access are very helpful for me.
Maraming salamat sa panonood
Very well explained
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,
Just check the syntax compatibility. Because sometimes you need to change the * to %.
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
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.
Thank you so much sir.
شكرًا
Hi. Thank you so much.
Your video very helpful to us.
Thanks for watching Deep.
Well done Sir, thank you...learned a lot from you...salamat...
Maraming salamat din po.
very nice and very useful and simple thank u Dr VR SUBBIAH FROM INDIA
Thanks Doc. It's highly appreciated.
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.
Every textbox has a purpose. Try to make in actual using only 1 textbox and you will know.
Thank you for watching.
@@EdcelleJohnGulfan I understand. SO MS Access cannot build and run a query on "the fly"? Would you explain it please?
@@jaysonwonder6667 i think cause it's a list and you should extract only text to use it in the query
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.
Thank you very much for the tutorial
Welcome Ruedi.👍
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?
will you please guide me as you teach in your vlog search with codes .I have problem while conditional searching .I have made a form where searching is on Service No .I want to search service No with condition like "and" against billing month. Guide ??
very awesome video sir. thanks for valuable sharing.
Your welcome sir. Thanks for watching.
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 ?
Same with this link.ua-cam.com/video/0Yy6GZdd17U/v-deo.html.
This method is open specific record but using list box. I Will create tutorial about this.
Thanks for the question
Holy crap. I never thought to use a list box that way!!
Thanks for watching.
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.
Open specific record: ua-cam.com/video/Uo5pV_wQ4sc/v-deo.html
Try this also: ua-cam.com/video/APQVs3FpebY/v-deo.html
great work thank you tracher
Welcome
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?
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
This is the solution.
ua-cam.com/video/LA7Fntikys0/v-deo.html
GREAT, I WILL TRY SOON
Thanks for watching Abdul.
Thank you very much! God Bless!
You are very welcome.
Great job
Thank you so much.
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?
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.
Hi Gulfam, when load my navigation form query give me error because textbox keeps blank at the time of loading..
Can you paste your code here?
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!
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.
You have to publish it in asp.net but there's a lot of changes.
can you do same exercices wirth 2 combobox search
Yes sure soon. Thanks for watching.
Hi Edcelle, how about when we put the Search Form in a Navigation Form , subform
When you encounter an error follow this one.
ua-cam.com/video/LA7Fntikys0/v-deo.html
@@EdcelleJohnGulfan thank you my friend
You're welcome. Thanks for watching this video.
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.
No need to buy. A lot in UA-cam.
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.
Just insert a text box in the form and name it as searchtext and searchbox
@@EdcelleJohnGulfan same problem.
How do i send the results to a report for print
I have video on that for upload soon.
Brilliant
Try this
ua-cam.com/video/APQVs3FpebY/v-deo.html
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?
Use .SETFOCUS
@@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.
Awesome
Thanks for watching
Thanks
You are welcome
Very informative sir , can you make a video stock in and out automatically using ms access? Waiting for your new video…..! Thanks 🙏
Thank sir.
Set initial stock level, then query [initial stock level] minus (-) [number of items sold] (count) . Aggregate query.
Tanks a lot sir
How to link one text box to another text box in ms access. Pls help me.
Kindly expound what you want?
Nicely done, understandable even for rookies! ;)
Thanks for watching.
Hello , how please you create a beautifull dashboard like yours
Yes sure.
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???
Yes, it's possible.
Click specific data t open specific records in different form.
Want search listbox value export to pdf or excel
We will create that soon.
Maybe you can get idea from this video. ua-cam.com/video/APQVs3FpebY/v-deo.html
I have a text search box on my database, but that’s not search you type , now I will make it search as you type
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, 🤔
Why do you need to retrieve? Is it lost? Or something corrupted?
Sir pde b maging clickable un result. Sample if description nkhide n dun s result at pg click ko lalabas boung information
Pwede po. Properties setting lang yan.
Hai,
Can we get an example of the MS Access this file ?
Thanks.
Yes.
Send me your email.
How to export list box data in pdf
I will create video soon
hi sir good pm, pde po pagawan kung paano maiiprint or magiging report yung na filter . thank you..
Ok po. Salamat sa suggestion.
Kuya. Ok yung content mo. Sana mapapalakasan mo ang audio tapos matatangal ang background noise
Next time po. Yan po problem ko. Salamat sa panonod.
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.
Kindly have a sample Sir Rovetto.
By the way, thanks for watching.
Ng eenter parameter po kpg gagamitin q navigation control kpg open q ung list form.
Simple lang po yan. Delete your parameter, me a new one using build expression yata yan. Yang nasa itaas.
Your video, sample database and VBA are good but the video is blurred.
You can adjust the quality of resolution. Click the setting icon on UA-cam video and choose 720 or Up to view clearly.
@@EdcelleJohnGulfan Thank you! I've got it.
how to remove enter parameter value From!List Equipment!SearchText
Open your query and delete the creteria.
explanation not quite clear.