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 - ua-cam.com/video/x7EvGesXGTk/v-deo.html
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?
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.
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!
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.
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.
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 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?
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.
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.
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
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...
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.
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.
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!
This solved hours of work. Thank you so much!
Great to hear an Aussie voice in a very useful video.
thank u sir, you gave me a solid start for dynamic queries. thank u so much.
This is exactly what I was looking for to make Access do what I needed. Thanks a lot !!
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 - ua-cam.com/video/x7EvGesXGTk/v-deo.html
Excellent. Thanks a lot for your valuable lesson. Subscribed & definately liked! Looking forward to more tutorials 👍
You solved my problem bro thanks❤
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?
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.
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!
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.
Thank you it worked perfectly.
This is a great tutorial. 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.
Excellent tutorial, many thanks!
Is there any way to integrate this query into the same form? If you click generate it would generate it in the same form?
Thank You Very Much Sir, May you live long "Ameen"
THANK YOU SO MUCH FOR THIS VIDEO
Can we add integrate "from date" to "to date " in this form? Please guide.
Great video, thank you!
Thanks. Precise, small but complete. Really did help me.
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.
Thank you Sir
Thanks you, very helpfull
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?
This is what I am looking for
I want the result to display in the form itself
How can I implement it
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.
thank you so much
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.
Amazing! Well done and thank you for making this video! Saved me hours! :-D
Hello, can you shpw me the mysql code for this? i'm having trouble with mine. Thank you
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
How to export the data once this is completed?
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. ua-cam.com/video/x7EvGesXGTk/v-deo.html
Regards
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
king
In future if you are integrating date selection in future please let me know, however I have activated notification.
How to
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.
First
طررررش
Everything's fine until you close the form