Search results for query: *

one day i should invest time on how listeners for events work on VB, looks really strange too me, not implemented like in other langages. This sub does same that your code but : * work faster (uses a SQL statement) * allow Macros * allow use of filter * do not need to know field name to filter...

change by : is this done by office engine when setting mCombo.Onchange = "[Event Procedure]

i do understand how classes and instantiation works :) as you see it was more questions :) In fact, for many reasons and problems i had in past with it, i never trust microsoft object implementation by default. I would not have asked that with java. i was not sure that both Combo0_Onchange()...

I do not know, coz i create forms and SQL request dynamically in my program. (i could know but will make much more code for me and loss of perf) but your right for solution, this is why i implemented it, but need to check system list separator from windows local. works but does not really please...

in intitialize : Set mCombo = TheComboBox ' all modifications to mCombo and mForm will be effective on TheComboBox Set mForm = TheComboBox.Parent ' and its form. this is not a new instance just a link to the combo and its form (...) mForm.OnCurrent = "[Event...

it s a bit late here in thailand i will check more your class tomorrow but thanks i think i can improve it. i didnt used it but read your code. what do my code and not your code, major improvements of your code i think about : * you need to know field name to filter. * your code seems to...

same new function with original search method LIKE '*T*E*X*T*' instead of LIKE '*TEXT*' still have to : set autoexpand to No add declare function in a module add collection to form declaration Private Sub Combo0_Change() ' Only have to adapt this to your own function ' Function Description...

i forget to say that you still have to : Set autoexpand to No :)

hi, I had to use this FAQ for one of my software, so i made major improvement in the code No need for developper to adapt code for each new function as before. Now this fonction work with : ALL SQL STATEMENT (without changing the code) ALL WINDOWS LOCAL SETTINGS ALL NUMBER OF HIDDEN COLUMNS...