Wow! Great tutorial. I spent 8 hours yesterday trying to get this functionality in our database with little progress. After viewing your video...SUCCESS!
Cbern, check the name of the new drop down menu on the form you are using and make sure that the name matches the criteria in the query. You can find the name of the new drop down, text box, etc in the properties of the form. The query should have a filter by [Forms]![Name of Form]![Name of combo box or drop down menu]. I hope this helps.
In the last part of the Video, how do you resolve the POP up " Enter the Parameter Value for Combo1 " ? Also when I enter the Forms ! Name of form ! Combobox name , the query is not displaying any records..
while changing text on combo box (Vendor Name) like 'hotel'. I need to get query from 'VendorDetail table' (SELECT vendorname FROM vendordetail WHERE [VendorName] Like "*hotel*") The result needs to add in combo box. Please advice, thx.
Shrye2009: If I understand your question correctly you should only need one report and one query. Include in the query the manager field which can be filtered a criteria similar to the tutorial. You should not need a report for each manager. You should have one report that populates with the managers employees. If you filter the query then the report should work the same way. Hope this helps.
Is there a way to do this using two combo boxes to filter the report? For example I have different coloured boxes and different numbers of each colour. So i'd want a combo box for box colour and a combo box for box number. But when I've tried the report just remains empty.
Hi, i have tried to follow your video instructions, my query works fine, however on the form when you click the Command box, it asks for parameter values. Where could i possible be going wrong?
Hello, can you please help me with my data type? What data type did you use on your client Id and Job_ID to create the relationship? I I'm having mismatch in expression. Thank you.
Hi! I'm quiet new user to Microsoft Access. as a beginner user its hard for me to understand. is there any easiest way to view a specific entry report using combo box? as combo box is capable to filter multiple of field at the same time.
I have a quick question I have 5 queries I have placed together in one Union all quire I tried what you showed above and it didn't work, Basically I now have 15 union all queries based on 15 different managers, and with that 15 different reports. I Have 1 main union query report with all employees and want to set it up so I can select the manager and generate a report for only that manager's employees.?
Instead of referencing a table you can enter the data manually, then just enter the range of dates you want. That should be the only thing you have to change. Though, depending on how widely and regularly the dates will change you many not want a combo box and instead just go with having the user manually entering in the desired date ranges.
hi I have 2 combobox when I choose data in 2 of them it show the data in report but when I choose data only 1 combobox and leave another one empty it show nothing in report please help me
I spent hours trying to build a report with criteria! Once I found your video, it took me 20 minutes! Thank you so much, you saved my sanity!!!!
Wow! Great tutorial. I spent 8 hours yesterday trying to get this functionality in our database with little progress. After viewing your video...SUCCESS!
Great video. I wish the video and the sound followed each other better
Video is out of sync with audio but got the answer I was looking for, and my form/report/combo box combination works a treat thank you.
You dont even know how much how I love you, I really needed this last part to end my work, thank you so much !
Cbern, check the name of the new drop down menu on the form you are using and make sure that the name matches the criteria in the query. You can find the name of the new drop down, text box, etc in the properties of the form. The query should have a filter by [Forms]![Name of Form]![Name of combo box or drop down menu]. I hope this helps.
Great tutorial and thank you very much sir...finally You solved my problem with my Invoice application..great job
Thanks for the knowledge!
I like to thank you for sharing your knowledge....this video served my query.
In the last part of the Video, how do you resolve the POP up " Enter the Parameter Value for Combo1 " ?
Also when I enter the Forms ! Name of form ! Combobox name , the query is not displaying any records..
Thanks dude! I was searching the web to find this for a week and i'm very grateful now :)
while changing text on combo box (Vendor Name) like 'hotel'. I need to get query from 'VendorDetail table'
(SELECT vendorname FROM vendordetail WHERE [VendorName] Like "*hotel*")
The result needs to add in combo box.
Please advice, thx.
Shrye2009: If I understand your question correctly you should only need one report and one query. Include in the query the manager field which can be filtered a criteria similar to the tutorial. You should not need a report for each manager. You should have one report that populates with the managers employees. If you filter the query then the report should work the same way. Hope this helps.
Great tutorials but how do you make empty combo box select all values in the report?
Is there a way to do this using two combo boxes to filter the report? For example I have different coloured boxes and different numbers of each colour. So i'd want a combo box for box colour and a combo box for box number. But when I've tried the report just remains empty.
Thank you so much. This video helped me immensely
audio is way out of sync from the video....makes it very hard to follow... 3out 0f 5
Thanks a lot. its works. thanks again.
What if you want an "All" feature that will show all records if none of the filters are used or if you have multiple filters and only some are used?
I cannot get the criteria to work me me. Trying to follow video with talking does not work, plus screen at the bottom is cut off some.
This was great! really helped me out of a bind~
Hi, i have tried to follow your video instructions, my query works fine, however on the form when you click the Command box, it asks for parameter values. Where could i possible be going wrong?
Hello, can you please help me with my data type? What data type did you use on your client Id and Job_ID to create the relationship? I I'm having mismatch in expression. Thank you.
really helped,thanks a lot
you have any vids about how to show dates in chart?
Hi!
I'm quiet new user to Microsoft Access. as a beginner user its hard for me to understand. is there any easiest way to view a specific entry report using combo box? as combo box is capable to filter multiple of field at the same time.
i had tried this but after i insert the criteria my query become empty
can anyone help me?
I have a quick question I have 5 queries I have placed together in one Union all quire I tried what you showed above and it didn't work,
Basically I now have 15 union all queries based on 15 different managers, and with that 15 different reports.
I Have 1 main union query report with all employees and want to set it up so I can select the manager and generate a report for only that manager's employees.?
thanks best tutorial!
This is amazing!
How could I do these but with Dates in the ComboBox filtering the Query?
Instead of referencing a table you can enter the data manually, then just enter the range of dates you want. That should be the only thing you have to change. Though, depending on how widely and regularly the dates will change you many not want a combo box and instead just go with having the user manually entering in the desired date ranges.
I follow your tutorial but my report is empty when using combo box. but when i type the criteria it shows result
Was having the same problem. Just redo the report from the query and itll work
the same problem with me
hi I have 2 combobox when I choose data in 2 of them it show the data in report but when I choose data only 1 combobox and leave another one empty it show nothing in report please help me
how did you get 2 combo boxes to work?