This is a tutorial done by BenC to demonstrate the use of form-based combo box input that drives the query to display the result back in the same form.
I am trying to do something similar (bit more complicated). I have a textbox where I type something, then I try filter a list underneath it. say I have a list of first name, last name, email, and I want to find a person with "ll" in their name, then I type "ll" in the box and it will filter down the list to Hill, Williams, Miller, Allen, Hall, Mitchell ... etc and I want it on the "onChange" event so its automatic. How would I do that? Any tips? To make it even more complicated I also have a "checkbox" next to it, where I can turn on and off the filter. My idea was to put a hidden box somewhere that get's it's value "" when checkbox unchecked, otherwise it matches the value from the original textbox. then I do a "Like "**" criteria..I'm just not sure how to extract the value from that textbox and put it inside the ""
I have a database I have inherited for use at work and since upgrading to Office 365 I am now getting the error message - The command or action 'Requery' isn't available now. Then the bottom of the message says, Use only those commands and macro actions that are currently available for this database. I know its vague, but do you have any idea as to how to rectify this error message?
The requery,I believe was a command under the macro functions. The requery would action when a new piece of data was entered. This tutorial was how I resolved this.
The necessity to hit a button to get the query updating the result is what kills this. Should update automatically upon completion of data entry = much more user friendly.
Awesome, Since I am retired person but still learning. It's my passion.
Thanks
I have been looking everywhere for this. You are amazing.
Thank you! This was what i was looking for.
N1
I am trying to do something similar (bit more complicated). I have a textbox where I type something, then I try filter a list underneath it.
say I have a list of first name, last name, email, and I want to find a person with "ll" in their name, then I type "ll" in the box and it will filter down the list to Hill, Williams, Miller, Allen, Hall, Mitchell ... etc and I want it on the "onChange" event so its automatic. How would I do that? Any tips? To make it even more complicated I also have a "checkbox" next to it, where I can turn on and off the filter. My idea was to put a hidden box somewhere that get's it's value "" when checkbox unchecked, otherwise it matches the value from the original textbox. then I do a "Like "**" criteria..I'm just not sure how to extract the value from that textbox and put it inside the ""
I have a database I have inherited for use at work and since upgrading to Office 365 I am now getting the error message - The command or action 'Requery' isn't available now. Then the bottom of the message says, Use only those commands and macro actions that are currently available for this database. I know its vague, but do you have any idea as to how to rectify this error message?
The requery,I believe was a command under the macro functions. The requery would action when a new piece of data was entered. This tutorial was how I resolved this.
Hi, great video, how about if i have a birthday and anniversary queries how can i put that in a form and update? Pls help
you can do it without the update button with VBA
The necessity to hit a button to get the query updating the result is what kills this. Should update automatically upon completion of data entry = much more user friendly.
CAN YOU REQUERY A TABLE?
sorry caps