Creating a Form-Based Parameter Query - Dynamic Queries
ฝัง
- เผยแพร่เมื่อ 19 เม.ย. 2017
- In this tutorial we will make a Form based Query where they information is taken from an object on the form to be used as Criteria in our Query. this is sometimes known as a Dynamic Query where the user determines the criteria.
This is exactly what I was looking for, great instructions and easy to follow along. Thank you.
As others have said: this is exactly what I was looking for, and really clearly explained. Many thanks!
Great to hear an Aussie voice in a very useful video.
This is exactly what I was looking for to make Access do what I needed. Thanks a lot !!
This is a great tutorial. Thank you.
Thanks. Precise, small but complete. Really did help me.
Thank you man. This wasnt an exact solution to my exact problem, but it allowed me to make a decent work around for now until I can go back and work on it. I am trying to learn access on my own and I figured Access 2016 would have a macro for a button that just let a user generate their own reports, but I was wrong.
But as I said, until I get that figured out, I think this will be a decent work around for a beginner.
Have a look at the following tutorial I recorded this week as it covers basic form based query and display through to reports - th-cam.com/video/x7EvGesXGTk/w-d-xo.html
This solved hours of work. Thank you so much!
Excellent tutorial, many thanks!
thank u sir, you gave me a solid start for dynamic queries. thank u so much.
Thank You Very Much Sir, May you live long "Ameen"
Great video, thank you!
Absolutely brilliant!!! Exactly what I needed and so easy to follow - thank you so much! Would there be a way to make the button show the results in Report form for printing? Perfect 7 minute tutorial!
You could create the image of a button and then place the filed / summary field on the top of the button. So when it prints you will have a button with the information on top. That would be the quickest workaround.
Excellent. Thanks a lot for your valuable lesson. Subscribed & definately liked! Looking forward to more tutorials 👍
Thank you it worked perfectly.
THANK YOU SO MUCH FOR THIS VIDEO
Amazing! Well done and thank you for making this video! Saved me hours! :-D
Clearly explained Thank you. Is there a different critera structure for Crosstab queries? I've tried this approach only to get error messages indicated 'MS Access database engine does not recognize the criteria as a valid field name or expression'. Same criteria works on select queries without any problem!
Thank you
Hi Leon,
I've been trying to do the query the way you showed it. However, I think my table is set up wrong. I have the subject headings in the columns (art, math, Social Studies, etc.) with a yes/no data entry. Could you show me an example of the table you used for the combo box and query? Thank you.
Thanks you, very helpfull
Great tutorial. Thank you. I have a question, when you close the query and return back to the form, the combo box still displays the previous selection. Is it possible to make this box clear ready for another selection?
This works great when I run my form itself. But when I run the form through a navigation form it does not work? Can you explain why this is and what would resolve this?
Thank you Sir
thank you so much
Is there any way to integrate this query into the same form? If you click generate it would generate it in the same form?
Hello!
I understand this is an old video so you may not still be actively reading the comments, however, I'd like to know if I had multiple fields (combo box and unbound text boxes) would it still work the same way in terms of using them to create the criteria in the queries, thanks :)
You can have a query that reads from the Form and Field for one criterion (like a start date) and then another form and field for the other parameter for the query. You can not have 2 criteria to control a subform as this must be done via a query and result back to a new form. Hope this helps you on your journey. Cheers
@@LeonMarsden Cheers for the reply, very much appreciated as I'm sitting my computing exam in the next few days
Hi Leon, Can you please explain the same for list box with Multi-select property enabled. I created a form with a list box for filtering value from a table and when I filter the results using parameter criteria in another query it does not work. When I disable multi-select property it is working but When I enable multi-select it does not filter and just displaying all the results. I just want to know what is criteria to filter using multi-select list box.
It is only applied on the primary Key and It might be because the values in the combo box bound to that key. I tried to use the parameter criteria on other fields (non-key fields) and it failed to work.
king
Hi Leon.. Need your help.. In Microsoft access if we want the form to display total in numbers.. For example the total of new job, total of pending jobs, total jobs waiting for spare parts and so on.. Is it possible
This would be an unbound field on the form that will look at the data in the fields generated and sum them up. It is some time since I have used access now as I have moved into web solutions using PHP and MySQL. Hope this helps.
Can we add integrate "from date" to "to date " in this form? Please guide.
I am using Access 2016. when I am inserting combo box, the wizard which is shown in this video didn't show.Please Help.
From about 40 seconds of the video you will see how to create a blank form. From the blank form you can select design of the top tab. From there locate the combo box, this should be about the 9th icon from the arrow being number 1. Just hover over the icon and the name will drop below. Click and drag out the area on the form. The wizard will action after you mark out the area. You can resize after the wizard finishes. Hope this helps.
Thanks
HI I Need a help
I am able to create conditions(15 steps of process and their delay status - Done, Balance, Delay) and display in the form. But I cant apply this same conditions in query. It says too complex.
This is what I am looking for
I want the result to display in the form itself
How can I implement it
Hello, can you shpw me the mysql code for this? i'm having trouble with mine. Thank you
Thank u for the video . But why do you close the query every time for a new search if it is a dynamic query ? Can't i search it without closing it before running the query again ? More over this approach will not be helpful when i want to run in full screen mode because the query result will be in the software, whereas i would like to have it popped up like a form .
Thank u ... It would be nice if u can reply on this...
This video may be of more use in the outcome you are looking for. th-cam.com/video/x7EvGesXGTk/w-d-xo.html
Regards
First
How to export the data once this is completed?
Query is not getting value form the combo box
It is suggested that you may need to go back to the start of the tutorial and ensure that you have named everything correctly. Hope this helps you resolve the missing link.
@@LeonMarsden thank you for the reply.the problem was that the combo box i used was sending the primary key value to query instead of the actual value shown in combo box.
How to
In future if you are integrating date selection in future please let me know, however I have activated notification.
طررررش
Everything's fine until you close the form