[AccessD] Fast clicking

Debbie delam at zyterra.com
Wed Oct 6 16:53:18 CDT 2010


I have a form in access 2007 that has a lot of code that runs when  
certain events happen. These take several seconds to complete and  
occasionally if a user changes thier mind or gets impatient and clicks  
elsewhere before the code finishes I get errors and problems.

For example: I have an option box that shows or hides various  
subforms. Click between then quickly and before too long you will get  
stuck on one option and can't change it without changing something  
else in the form then going back.

Still doing my best to educate fast clicking out of them, especially  
on this form, but ideally I need some way to keep new entry from  
happening while code is running. I have just experimented with an  
inconspicuous modal form that opens on code firing and closes when it  
is done, but still get the option button sticking. Either I need a  
different solution, or the problem is not what I think it is. Anyone  
have any ideas?

Debbie

Sent from my iPhone



More information about the AccessD mailing list