[AccessD] Fast clicking

In addition, you should wrap the event code in:

DoCmd.Hourglass True
Application.Echo False 
...
Application.Echo True
DoCmd.Hourglass False


This will freeze the screen and prevent them from clicking anywhere else
until Echo = True.  Your code may run faster because there will be no screen
changes.

When you use Application.Echo False you must set up error trapping in that
procedure.  Then place Application.Echo True into the code that runs after
an error happens.

Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
Sent: Wednesday, October 06, 2010 5:12 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Fast clicking

First thing I'd do is wrap the event code in

Docmd.Hourglass True
...
Docmd.Hourglass False

to discourage them from clicking.  

If that is not enough, I'd have a sub which steps through all the controls
on the form and 
either enables or disables them based on a parameter. Then wrap the long
running code in 
two calls to that function.

-- 
Stuart

On 6 Oct 2010 at 16:53, Debbie wrote:

> 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
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com