@@EdcelleJohnGulfan I have a question. Is it possible to have two search boxes on the same form? I have the first box set up to only search name and address. The second I tried to set up to search fibers but it will not update as you type. The first search box works like it should. The information is all in the same Tables and Forms. I set up a second Query for it.
This is EXACTLY what I needed for work, my boss was really impressed, you’ve got my sub! My only questions would be, is there a way to make it to where you can’t edit the product list, just a form or table? And when you search something if you could click on a row to select it, then use a “open form” button to be taken to that form?
It helped me a lot, thanks for it. One constructive feedback. Try to explain without all the text and field format. I lost track of what was going on. cheers
A fantastic video, i have only two gripes, the music was way to loud verses your voice, could not hear a lot of what was said :( and sometimes you go a little quick with no explanation (that I heard anyhow) especially when changing some of the settings in properties. But, that being said and after a lot of pausing and scrolling backwards and forwards this video helped me out considerably in my current project. Thankyou :]
Agreed. Your video content and the vba techniques taught are great. Thank you. However, please remove the music. We want to hear your voice and explanations of everything you are doing on the screen, NOT music. Other than that, please keep up the good work.
i have done it well and work perfectly but 1 question " when one more than data input in same Id " then not working. please help me answer EX:I have a book issued Form so under 1 id many book stored.
My friend, this is excellent! Im working a lot on Access since the past 2 years and your channel is a goldmine! If you'd like, I'll be glad to share with you a way to export reports in excel pre-made templates involving powerquery.. but surely you already know how to do that :D. Greetings from Italy!
Thanks so much for this video! Very nicely done and extremely helpful tutorial. Could you explain why the dummy search box is needed though? Couldn’t the same search and query be accomplished with just the main search box? Sorry…I am new to VBA programming in Access.
Nice question. Since we're using ON CHANGE EVENT Function, the form will refresh every changes being made. If we use the main search button, that button will refresh its focus and you cannot type your words continuously.
Good day sir. I have a question. I have a lot of controls (text fields), how am I going to organize this in a form? In my Table, I have 30 Questionnaire. How am I going to put this in a form?
Thaml you for this awsome video. When I put form with searchbox to navigation menu, "Enter the value of the parameter-DummySearchBox" shows. Can you help me?🙏
@@EdcelleJohnGulfan So, there is no way that directly typing >60 in the search box and return the result list with above 60 yrs old right? The search box can only return result with particular text value, right?
If I have Race column where we type different races and I want the Country column be filled out automatically. If I type Mexican on the Race column, I want the Country column displays Mexico as stored value not on the fly. I have already made a table that have 200+countries listed from A to Z. So and the another table will have Race column and the country column will be empty. I want to avoid combo box, because I get tired to click on the combo box over and over to select country. So is there a way to have the country column being fed automatically?
@@EdcelleJohnGulfan I am really sorry didn't mean to hurt you as the video was very helpful and also appreciate your ability to take the feedback and work upon. Mpty bro.
You can just edit by opening the original file. And if there's table that needs to be modify, you can copy paste the tables from the backend to your front end and split again once done.
hai, can u explain why everytime i want to open the form, ms access asks me to enter parameter? and everytime i type in a letter in the search box, ms access keeps on asking me to enter parameter. thank you. love your video btw.
I would have the form built already and just show the functionality, the code, too long. Do form building in another video for people who didn't know how to do that. Just solve the title issue, that's what I'm here for, not how to make a pretty form.
@@EdcelleJohnGulfan Ok done. But whenever I will write in the Search Box it will show error: "Run-time error '2185': You can't reference a property or method for a control unless the control has the focus"
I also have the same error message when value isn’t found. Is there anything I’m doing wrong? The search works fine until I type something that is not found. Thanks
Not sure if I missed something but after I type the first character in the SearchBox, the focus shifts to the first column in the subform. How can I fix it?
Great tutorial and exactly what I was looking for! Not only did I learn how to make the search function, but I also picked up some nice tricks when making a form look amazing aswell! :D Thanks so much!
Thank you for all the tutorials you have made for access. You make it easy to follow and understand
Thanks for watching. Your comment is highly appreciated.
@@EdcelleJohnGulfan I have a question. Is it possible to have two search boxes on the same form? I have the first box set up to only search name and address. The second I tried to set up to search fibers but it will not update as you type. The first search box works like it should. The information is all in the same Tables and Forms. I set up a second Query for it.
This is EXACTLY what I needed for work, my boss was really impressed, you’ve got my sub!
My only questions would be, is there a way to make it to where you can’t edit the product list, just a form or table? And when you search something if you could click on a row to select it, then use a “open form” button to be taken to that form?
EXACTLY TIMOTHY! You're in right channel 😄😄😄. This is what you need. Follow this link: th-cam.com/video/Uo5pV_wQ4sc/w-d-xo.html
Thanks! This is the most complete & useful technique I've seen. And I've seen several ways to accomplish similar results.
Thanks. Your comment is highly appreciated. Thanks for watching my videos.
Absolutely magnificent. Just the versatility I needed.
Thanks for it.
You make everything look easy. Thanks!
Thanks
It helped me a lot, thanks for it. One constructive feedback. Try to explain without all the text and field format. I lost track of what was going on. cheers
Thank you
Ps : I like the background music
I don't know wether is the music or your great prestation which makes me learn faster 🤓
Thanks for watching.
A fantastic video, i have only two gripes, the music was way to loud verses your voice, could not hear a lot of what was said :( and sometimes you go a little quick with no explanation (that I heard anyhow) especially when changing some of the settings in properties. But, that being said and after a lot of pausing and scrolling backwards and forwards this video helped me out considerably in my current project. Thankyou :]
Thanks for the comment men. Highly appreciated. I hope also in the next video, i have a good quality output.
Agreed. Your video content and the vba techniques taught are great. Thank you. However, please remove the music. We want to hear your voice and explanations of everything you are doing on the screen, NOT music. Other than that, please keep up the good work.
i have done it well and work perfectly but 1 question " when one more than data input in same Id " then not working. please help me answer
EX:I have a book issued Form so under 1 id many book stored.
My friend, this is excellent! Im working a lot on Access since the past 2 years and your channel is a goldmine!
If you'd like, I'll be glad to share with you a way to export reports in excel pre-made templates involving powerquery.. but surely you already know how to do that :D.
Greetings from Italy!
I'm very excited to accept that.
You can email me at eduardogulfan@gmail.com.
@@EdcelleJohnGulfan Super! Im gonna prepare a template and a lil bunch of data and im gonna send it to you :)
@@EdcelleJohnGulfan I just sent it to you :)
I hope you'll like it!
Thank you so much. I Received it.
ayus! pero mas ok sana kung may subtitle para masmadaling masundan. keep it up.
thank you This is what I looking for
Thanks for watching
Thanks so much for this video! Very nicely done and extremely helpful tutorial. Could you explain why the dummy search box is needed though? Couldn’t the same search and query be accomplished with just the main search box? Sorry…I am new to VBA programming in Access.
Nice question. Since we're using ON CHANGE EVENT Function, the form will refresh every changes being made. If we use the main search button, that button will refresh its focus and you cannot type your words continuously.
Thanks for asking Alex
Oh ok, got it…thanks again! Would it be possible to incorporate separate date range text boxes on this form?
Great tip. Thanks a lot!!
Thanks for watching man.
Thanks so much for this video
Welcome Hematullah.
Very Nice!!! outstanding!
Thanks for watching
@@EdcelleJohnGulfan How to pass values from one form to another?
Last part of this video.
th-cam.com/video/tJsjVKAM54Q/w-d-xo.html
Very helpful video thanks a million.
You are welcome
Good day sir. I have a question. I have a lot of controls (text fields), how am I going to organize this in a form? In my Table, I have 30 Questionnaire. How am I going to put this in a form?
Do you have a tutorial of using search with more than one term? Not necessarily while typing. Thanks for the video.
This video is a multi-field search form. th-cam.com/video/oFCW07r65Sg/w-d-xo.html
Thaml you for this awsome video. When I put form with searchbox to navigation menu, "Enter the value of the parameter-DummySearchBox" shows. Can you help me?🙏
This is the answer.
th-cam.com/video/LA7Fntikys0/w-d-xo.html
My form has text, combo and list. Can I write separate code for the (1) search box?
Thank you for your sharing. May I ask how do I apply expression like >, >=,
Create a query and write this expression:
Age: Between (form![NameOfForm]![from] to form![NameOfForm![to])
@@EdcelleJohnGulfan So, there is no way that directly typing >60 in the search box and return the result list with above 60 yrs old right? The search box can only return result with particular text value, right?
> symbol is a string and the 60 is an integer. You cannot calculate with a letter.
thanks for this, but is there a download for the template?
Go to minute 11 to finally get to the solution
Sir Thank you po sa mga tutorials nyo :) Sir meron na po ba kaung tutorial Pagination View like 50 records at a time ang display. thank you po :)
Wala pa sir
ok , what about if in table field Combobox
If I have Race column where we type different races and I want the Country column be filled out automatically. If I type Mexican on the Race column, I want the Country column displays Mexico as stored value not on the fly. I have already made a table that have 200+countries listed from A to Z. So and the another table will have Race column and the country column will be empty. I want to avoid combo box, because I get tired to click on the combo box over and over to select country. So is there a way to have the country column being fed automatically?
Try this.
Dlook Up function: th-cam.com/video/areOh48NuLA/w-d-xo.html
Cascading Combo box: th-cam.com/video/-IE-aXR3olM/w-d-xo.html
THANK YOU!
Welcome and thanks for watching Gabriela.
Hi, Can you repost this video without the music ? Thanks
I'll create another one. Level up to this video.
Is is possible When I press F9 on text field then show popup. I am finding this on your channel cannot find
Maybe this is what you want.
th-cam.com/video/0Yy6GZdd17U/w-d-xo.html
Perfect sir
But i have question if i search for som data how can i save the search as a table ?
You can use query (make table). The data is in the query.
Thanks for watching
15:27 I've done everything up to this point exactly, but I get "Enter Parameter Value" for each field?
I have no idea where I have gone wrong here.
My bad! I had incorrect field names!
Thanks for watching Andye.
on change event not working?
Review the video. 😃😃😃
@@EdcelleJohnGulfan my Database not Working On Change Event proparly . solved this problem
Thanks
You are welcome
good one, just the background music was distracting you could have avoided that
I created a new one.
th-cam.com/video/oQTcLPVjkY4/w-d-xo.html
@@EdcelleJohnGulfan I am really sorry didn't mean to hurt you as the video was very helpful and also appreciate your ability to take the feedback and work upon. Mpty bro.
It's really ok. Thank you so much for the suggestion.
bakit ayaw sa akin ang continous forms pag naka subforms?
Check mo ang Form Property ng subform baka hindi naka-set as continuous form.
Hi sir. How can we edit the form in the front end after splitting the database
You can just edit by opening the original file. And if there's table that needs to be modify, you can copy paste the tables from the backend to your front end and split again once done.
@@EdcelleJohnGulfan thank you for the quick response..can we have different front end and edit individually?
Basically how do we change the forms in backend or front end
hai, can u explain why everytime i want to open the form, ms access asks me to enter parameter? and everytime i type in a letter in the search box, ms access keeps on asking me to enter parameter. thank you. love your video btw.
i found a video that u link to answer this question, but can u show how to fix it with the template shown in this video? thank you
I also tried it almost worked but when I open and type in search box it opens a box which says Enter Parameter values. Please solve my problem
th-cam.com/video/LA7Fntikys0/w-d-xo.html
Not visible
The query cannot be used as a row source
Why?
Hope i can the screen clearly...
Change the settings of your resolution. Click the gear icon in TH-cam video and select the high quality you want.
Sir Edcelle good Day po, ask sana ako ng tulong sa sinusobukan kung gawin na ID System.
Ok.
I cannot hear what you're saying over the music. Please remove the music.
Need a new microphone or learn not to "puh" into it. Distracting.
Suggestion, just focus on functionality and don't spend time making it pretty. Time for your viewers is precious.
I would have the form built already and just show the functionality, the code, too long. Do form building in another video for people who didn't know how to do that. Just solve the title issue, that's what I'm here for, not how to make a pretty form.
OMG dude you're killing me. Just show me the solution!
I created this new video because of some feedback. Please watch the mew Link.
th-cam.com/video/oQTcLPVjkY4/w-d-xo.html
What is the full code?
Is it:
ME.DummySearchBox"ME.SearchBoc.Text
??
Me.dummySearchBox = me.SearchBox.Text.
@@EdcelleJohnGulfan Ok done. But whenever I will write in the Search Box it will show error: "Run-time error '2185': You can't reference a property or method for a control unless the control has the focus"
I also have the same error message when value isn’t found. Is there anything I’m doing wrong? The search works fine until I type something that is not found. Thanks
Thank you very much for the video
Your welcome
pls help me how do i do this on a split form?
I like how you resized and aligned those form controls. Didn't know it closed the gaps like that with align left.
Thank you for watching.
Can't hear you over the music.
Try this new.
th-cam.com/video/oQTcLPVjkY4/w-d-xo.html
Thanks
You're welcome
Not sure if I missed something but after I type the first character in the SearchBox, the focus shifts to the first column in the subform.
How can I fix it?
I am unable to set it as continuous form after creating sub form from the query
Please share the link to download it..........Thanks.
This is amazing and you are wonderful it is so easy thank you 🎉
Thanks you so much.
Like"a" right??
Why you use both textbox? Why not only one
Try using one textbox and you will know the reason behind.
Hi Sir Good evez. Pano po f yong form ko is yong subform. Thank you
Napanood mo na to mam? th-cam.com/video/oFCW07r65Sg/w-d-xo.html
Great stuff! this is exactly what i needed!
Thank you so much.
Great tutorial and exactly what I was looking for! Not only did I learn how to make the search function, but I also picked up some nice tricks when making a form look amazing aswell! :D Thanks so much!
Very NIce. Good Job Bro
Thanks for watching Vel. See you to my next video.
¡Genial! ¡Gracias! Me sirvió
Welcome and thanks for watching
Nice touturial
Thanks for watching Al. See you to my next videos.
Excellent one
Thanks Ali
great
Thanks for watching
Hi sir.. Can this type of search be done on a form base?
Hi.. How can we do this with 2 different tables.. Like customer table and products table.. Pls advice
Is it two different subforms in one search form?
@@EdcelleJohnGulfan .its actually 2 forms in 1 page
Wow thank you This is what I looking for!, Can
Welcome. Thanks for watching
Awesome stuff here, thank you!
Thanks for watching.
saved my life today, thanks man
Thanks for watching.
Salamat, pare ko. I likes it!
Salamat din sa panonood pare ko.
Thanks a lot.
Welcome and thanks for watching.
mag wo-work po ba if ang subform mo po is Continuous Form instead of Datasheet?
Pwede po pero depende. Kung subform pwede ito pero kung main form talaga hindi.
Iba na coding pag continuous form
@@EdcelleJohnGulfan kapag subform mo po is Continuous form pwede po ba? sorry po d ko po ma gets konti. hehe