Thanks a lot for you help. I would like to ask you a question. I search on my form on surname section for example. But when i have many people with the same surname i would like to keep the search for the surname and search also for a specific name. Any ideas how can i do that ? How can i make two search boxes on the same form ?
Great tutorial, successfully did it twice in a row! Just something Im still struggling with is that I want to be able to copy all search results that appear in a vertical coloumn but I can only select one at a time
Ooooooh, I very much liked this video, that is so cool! I want to use it but I don't need it, LOL. But I"ll put it in the back of my mind that it exists in case the need arises. I'll save it to my TH-cam to reference later.
Hello Gulfan, thanks for your video, fuction fine. I have try insert this form in Navigation Form, but I get window with "Enter parameter value". I have also try with continues form, it works, but not 100%. Maybe you have expirience or can make video, how it works with Navigation form, thanks and regards
Hi, thank you for a fantastic insight. Can you make a search while you type with an option of choosing between two date range? And also export to excel, PDF etc or print list.
thanks this was a very good tutorial, I have a question, when I incorprate this into a dashboard as one of the tabs I get a pop "Enter Parameter Value" ? with Forms!frmSearchDeletedContent!txt_temp. any suggestions?
Hiii thankyou for posting tutorial videos, your videos has helped me so much! I need help with something, do you have a way to save specific customer record as pdf?
Because you cannot apply the On change Event with Requiry function in the Text box which is active. Try to use the original Search text box and let us see what happen.
hello, why is the need to use a dummy box instead of using directly the search box. I think there is a benefit of doing that, but I don get it. I will appreciate your comments. Thanks in advance.
hello po sir your videos is so helpful...pwede po ba kayo maka gawa ng sample video ng patient database na makikita po yung mga previous transaction nya po...thank you in advance😊
Dear Mr. John, I really enjoyed watching this tutorial. However, when I try to follow it, I get an error. It seems that Access does not recognize what F_Productlist is
Salamat Sir John kay klaro ang instructions sa video , naa kuy question, what if duha ka search bar ang naa pero same ra sila ug query source? Pwede ni mahitabo Sir John?
I keep getting the error "Form! Form (form name)! Name_Dummy_Txt. When I load the forms. I know you may not be able to tell me without seeing the form, but is this ringing any bells? have you seen this before?
hello po good morning, may data table po ako about school graduates. nagawa ko na po yung search bar nyo. gusto ko po sana na pag click ko sa school year, lalabas ang lahat ng students in that year. pano po yun? salamat po and god bless
You won my heart by incorporating feedback. Love from India
Thank you. It's highly appreciated.
This worked! Thank you, I would recommend using the names of fields; I had to keep pausing to see what you were referring to.
Thanks for watching. I'm glad it helps.
Thanks a lot for you help. I would like to ask you a question. I search on my form on surname section for example. But when i have many people with the same surname i would like to keep the search for the surname and search also for a specific name. Any ideas how can i do that ? How can i make two search boxes on the same form ?
Yes you can and apply the same method.
Great tutorial, successfully did it twice in a row! Just something Im still struggling with is that I want to be able to copy all search results that appear in a vertical coloumn but I can only select one at a time
Ooooooh, I very much liked this video, that is so cool! I want to use it but I don't need it, LOL. But I"ll put it in the back of my mind that it exists in case the need arises. I'll save it to my TH-cam to reference later.
Thanks for watching this video.
Hello Gulfan, thanks for your video, fuction fine. I have try insert this form in Navigation Form, but I get window with "Enter parameter value". I have also try with continues form, it works, but not 100%. Maybe you have expirience or can make video, how it works with Navigation form, thanks and regards
To solve, follow this...
th-cam.com/video/LA7Fntikys0/w-d-xo.html
@@EdcelleJohnGulfan Many thanks Gulfan for rapid answer, this solve my Problem!
You're welcome. Thanks for watching
veryyyyyyy useful video, thank you 💮💮
Thank you for watching
super job merci infiniment pour la vidéo car elle vient de me sauver.
I'm glad it helps. By the way, thank you so much for watching.
Hi, thank you for a fantastic insight. Can you make a search while you type with an option of choosing between two date range? And also export to excel, PDF etc or print list.
Ok soon
thanks this was a very good tutorial, I have a question, when I incorprate this into a dashboard as one of the tabs I get a pop "Enter Parameter Value" ? with Forms!frmSearchDeletedContent!txt_temp. any suggestions?
Hi thanks for watching.
By the way, just change your parameters and follow this steps.
th-cam.com/video/LA7Fntikys0/w-d-xo.html
Hiii thankyou for posting tutorial videos, your videos has helped me so much! I need help with something, do you have a way to save specific customer record as pdf?
Same concept with this.
th-cam.com/video/u_-0OK5I1qU/w-d-xo.htmlsi=RFnWjjW0MCu-LfHF
You can change your criteria of report for exporting and change the Excel to pdf.
Can you make video for search box exactly like it is on navigation buttons, to highlight found text and if I press enter to go to next record?
Nice idea. I will create a video soon.
Thank you. It works for me. Trying to understand what the DUMMY field does and why is it necessary?
Because you cannot apply the On change Event with Requiry function in the Text box which is active.
Try to use the original Search text box and let us see what happen.
When I use me.DummyText=me.Search.Text, there is runtime 1285 appeared; when I Change the text to Value, I can not input as anything. Can help to
That's why we should use .Text instead of .Value
Brilliant!!!
Thanks for watching carl.
hello, why is the need to use a dummy box instead of using directly the search box. I think there is a benefit of doing that, but I don get it. I will appreciate your comments. Thanks in advance.
Nice question.
ANSWER: You cannot type the whole word because the form will Automatically refresh every time you type the letter.
hello po sir your videos is so helpful...pwede po ba kayo maka gawa ng sample video ng patient database na makikita po yung mga previous transaction nya po...thank you in advance😊
History nya po. Soon gagawa ako. Salamat sa panonood.
Nice Thank You..
You are welcome.
Sir, what is the purpose of DumyText?
Hi Sir Edcelle how to print data po upon searching po.. Kindly teach me how to do it po..Thank you po..
Thank u very much 👏👏
You're welcome.
sir good day,, not sure why may error,, pro im using a continous form and buttons are ing the header,, error nya is runtime error2185
Ano ang error description nya?
Wery good thanks lot
Thanks for watching.
Dear Mr. John,
I really enjoyed watching this tutorial. However, when I try to follow it, I get an error. It seems that Access does not recognize what F_Productlist is
That's the name of the form.
You can set your own name.
very nice
Thank you for watching
Salamat Sir John kay klaro ang instructions sa video , naa kuy question, what if duha ka search bar ang naa pero same ra sila ug query source? Pwede ni mahitabo Sir John?
Nakasulay ko sa Date. (Date from and Date to).
Gamit lang ka AND FUNCTION or BETWEEN FUNCTION.
how do you put this in the navigation form?
Just change the criteria of your Query. To change.... try this link.
th-cam.com/video/LA7Fntikys0/w-d-xo.html
I keep getting the error "Form! Form (form name)! Name_Dummy_Txt. When I load the forms. I know you may not be able to tell me without seeing the form, but is this ringing any bells? have you seen this before?
Are you using navigation form?
@@EdcelleJohnGulfan yes. I figured that one out.
@@EdcelleJohnGulfan yes. I noticed that I had to re-run the build in the query. it is working now. Thank you!
I get runtime error 438 when applying the Me.DummyText = Me.Search.Text procedure
hi sir, pwede ka po maka upload kung paano mag auto refresh ng table and query?
Gawa po tayo video nyan soon. On Timer Event lang yan
hello po good morning, may data table po ako about school graduates. nagawa ko na po yung search bar nyo. gusto ko po sana na pag click ko sa school year, lalabas ang lahat ng students in that year. pano po yun? salamat po and god bless
Gagawa ako ng video about paglagay ng criteria sa query para ma-filter ang records.
Salamat pala sa panonood.
@@EdcelleJohnGulfan salamat po. may query na po ako pero di po ako marunong kung pano sila ma show sa report mag isa.hehe
Sir paano po mag add ng clear button sir ayaw po kasi mag run using macro builders po thanks
Why my search form only use single form 😢😢
You can convert your single form to continuous form. just go to your Form property and find the continuous form.
tooooo much formatting fastidiousness