How to only allow 1 button to be pressed at a time

[bradyboyy88]

So I have a few different buttons in a modeless vba form Each of these buttons runs ado queries on an access database. My issue is that 1 button can be pressed and while its still running and loading the query data another button can be pressed which tries to run another query. Is there anyway to only allow 1 button to be pressed or executed at time? Or make the macros go in order so when the one buttons macros are finished the next one would go right after?

 

[V_Malkoti]

1. You can disable other buttons at the start of click event of clicked button and then re-enable them at the end.
2. Keep a form level variable to check if a button click event is still running. Check the variable's value in each button's click to determine if it should be run.
3. If queries are supposed to be executed in order, then you can either hide/unhide buttons, or use a single button with updating caption, or use a multi-form design.

 

[bradyboyy88]

Number 2 is so obvious. I cant believe I didnt thnk of that hah. Thanks!!!!