This tutorial is so good. So, this video shows us how to calibrate 2 multiple list box and combo box, i want to ask how about there're more than 2 list box and combo box? Thankyou sir, Hope you always have a good day.
This is very cool... I have a question with your permission, in the 46th minute when choosing a state and then selecting a city from the Combobox works correctly, but when selecting and selecting more than one city it fetches data from another state that was not previously selected, unfortunately. How do I fix that? thank you.
Hi Khaled. Im not able to reproduce that error you mentioned. I found the Search Criteria function too complex, a result of coding while thinking rather than think then code. If you or anyone else reads this and reply I can provide 17 lines of readable code for the Search Criteria.
Thank you so much sir! This Videos are amazing. But I would like to ask something: I have a form with information about how long the citizens have lived in which state and city.I have txt boxes to give time range. I have comboboxes where I can select cities according to the selected state or states (Multiple Selection Options). And I have a report generation button that uses these filters.The problem is: if I want to generate a report without selecting state and city (both are not being selected), it doesn't show any data. How can I solve this? I did everything that you've done. My additional code is like: Private Sub cmd_SAll_Click() ' button for time range filter Dim strCriteria, task As String Me.Refresh If IsNull(Me.txtFrom) Or IsNull(Me.txtTo) Then Me.txtFrom.SetFocus Else strCriteria = "([LivingDate] >= #" & Format(Me.txtFrom "yyyy\/mm\/dd") & "# And [LivingDate]
This tutorial is so good. So, this video shows us how to calibrate 2 multiple list box and combo box, i want to ask how about there're more than 2 list box and combo box? Thankyou sir, Hope you always have a good day.
Another great video. Keep it up.
How would you create an invoicing system for a sub form?
would not be much more user friendly to use QBE? And not coded with VBA, just use a query as combo source? what is the difference?
Good video, how do I contact your for business?
This is very cool... I have a question with your permission, in the 46th minute when choosing a state and then selecting a city from the Combobox works correctly, but when selecting and selecting more than one city it fetches data from another state that was not previously selected, unfortunately. How do I fix that? thank you.
Hi Khaled. Im not able to reproduce that error you mentioned. I found the Search Criteria function too complex, a result of coding while thinking rather than think then code. If you or anyone else reads this and reply I can provide 17 lines of readable code for the Search Criteria.
@@pickavana8056 On 46:00 select for city.. my code it give me cities from another selected state.. indeed fix this. Thanks 😊
Same happened to me, have u fixed it?
@@pickavana8056 Hi can you help me with it
@@KhaledAbuDaqqa cascading comboboxes to limit cities available for selection based on states selected in first combobox.
Thank you Sir
Real you are great sir
Realy awsome sir. How to do if we want to display search result in report and print it out.
I already showed it on this tutorial. see the PrintPreview button section
Sir, Please Create Video Tutorial "Hotel Management System with Hotel Room Status".
Thank you so much sir! This Videos are amazing. But I would like to ask something:
I have a form with information about how long the citizens have lived in which state and city.I have txt boxes to give time range. I have comboboxes where I can select cities according to the selected state or states (Multiple Selection Options). And I have a report generation button that uses these filters.The problem is: if I want to generate a report without selecting state and city (both are not being selected), it doesn't show any data. How can I solve this?
I did everything that you've done. My additional code is like:
Private Sub cmd_SAll_Click() ' button for time range filter
Dim strCriteria, task As String
Me.Refresh
If IsNull(Me.txtFrom) Or IsNull(Me.txtTo) Then
Me.txtFrom.SetFocus
Else
strCriteria = "([LivingDate] >= #" & Format(Me.txtFrom "yyyy\/mm\/dd") & "# And [LivingDate]
Sir, thank you very much. What is your email address.