Richard, thanks for the timely video! The other day, I was working on a database and was wondering how I could filter the combo box!
@joshuajegede82533 ай бұрын
Thanks so much. This was super helpful on a project I am currently handling.
@599CD3 ай бұрын
Glad it was helpful!
@yawarabbas205Ай бұрын
Sir thanks so much you shared this code. I tried so much to find it but failed. Thanks again, sir. God bless you
@sheikhobaba Жыл бұрын
Thanks sir , Your all lecture are great. Love you
@mahmoudbarrawi7092 Жыл бұрын
Thanks Richard really you are doing great job
@nipcfo58934 ай бұрын
Hello I use your this combo box itext thing n my access app which has sequel server at the back end but it really slows down the entire form
@altdel126 Жыл бұрын
Excellent👍 I was looking for the same
@fdnyfish6 ай бұрын
I'm receiving an 2185 error after selecting from the list
@599CD5 ай бұрын
Run down the troubleshooter... 599cd.com/trouble
@thomaswesonga38689 күн бұрын
Enhance clarity maybe zoom for us
@marcellomg.giovannini41197 ай бұрын
Good job !!!!
@599CD7 ай бұрын
Thanks
@tonychaar67802 ай бұрын
Great one
@SonJboy45 Жыл бұрын
Sir Richard, thank you for all our videos. This is easier than searching solutions in google and Bing Chat often gives a link to one of your videos whenever I ask for some codes. I do also want to ask if there is a way to have power query feature in ms access? Power query can get data from different sources however it is only in excel.
@user-bj4lp3fr1o11 ай бұрын
Great video.
@599CD11 ай бұрын
Thanks
@dmenace9288 Жыл бұрын
Thanks heaps :)))
@imstevemcqueen11 ай бұрын
Very cool😊
@navisalomi Жыл бұрын
Cool. Very helpful
@janvanantwerp6574 Жыл бұрын
YUP very cool...
@doctorchinmoy Жыл бұрын
Great 👍 Can u explain how can the sorting be done first those name which begins with the text typed by the user and then wherever the typed text is in within the searched name?
@badmustunde6508 Жыл бұрын
Good day sir, I have being enjoying your tutorial recently, pls sir do you have anyone on student report sheet creation or the guide to develop one, thanks
@KentReynolds3 ай бұрын
Can anyone explain why it’s such a no no to have a space in a table name or field name ?
@599CD3 ай бұрын
I explain in detail in my Beginner 1 class. Essentially it's a pain having to remember to put [Brackets] around your fields ALL. THE. TIME. in SQL, in VBA, in query fields, pretty much everywhere. Just don't do it. :)
@ambrandaoyoutub Жыл бұрын
Hello Richard, thanks for your lessons, I learn a lot from them spite being on the free courses. I would like to ask you how can I join the lesson from "Microsoft Access Cascading Combo Boxes - One Combo Box Selection Filters a Second Combo Box" (After Update event) to the "How to Filter the Data in a Combo Box or List Box as you Type in Microsoft Access" (On Change event). I try to use in the "CustomerF" made in the cascading combo lesson (Country, State and City), filtering the "CountryCombo" with "On Change event" and using "After Update event" like you mention, and when I load the form or go to other record to fill it up with data, the "CountryT" continuous with the previous filter on that table giving the impossibility to choose another value to the "CountryCombo" field. Can you give me some insight? I think that I need to put some VBA "On Change Event" to remove the filter from "CountryT" when I load the form or go to another record after update the State and City field. Thanks.
@solution1009 ай бұрын
HI..Richard..The combox box work fine with the mouse to go down.the items. ..Now if i press the down key it just select the one the is focus. NOt practical. How can i put the down key simple to go to the next item or the up key..
@599CD7 ай бұрын
599cd.com/Ask
@mikemlazgar5700 Жыл бұрын
I tried this on a combo box on a continuous form, and as soon as I started typing all the combo boxes (for each record) blanked out. Will this not work with combo boxes on a continuous form, or is it something |I did wrong?
@599CD Жыл бұрын
You are correct that this technique will not work in a continuous form. There are some tricks you can play to get it to work in a continuous form and I cover something similar in the Extended Cut for this video: 599cd.com/Cascading
@faisalashfaq5428 ай бұрын
hi richard, big fan of your great work, please can you make a video where you can search in a search form and return the value to another form like you do in oracle forms L.O.Vs I really do need it
@599CD8 ай бұрын
599cd.com/FormName
@user-ew7hy9mk7m11 ай бұрын
Hello Sir, i need cmb list *Filter as type*
@nutsonbikes Жыл бұрын
Rick rocks again
@nlt-g3v Жыл бұрын
Unfortunately, this approach creates more problems than it solves. If you type something and after filtering you want to browse through the options suggested with the up and down arrows on the keyboard then an unpleasant surprise awaits the user. You are forced to navigate with the mouse otherwise with the first movement of the arrows all options are lost!!! Even worst if you choose one option and go to create new record then in the new record if you open the dropdown with mouse then it has only the previous one!!! So if you want to see all the options you are in a nightmare!!!