Debbie
delam at zyterra.com
Thu Oct 7 12:16:44 CDT 2010
Thanks. This has cleared up some problems and made this form run faster. I was a bit troubled that the option group was still having trouble, but I found the solution. The option box had a solid background, and when I clicked on the box, but not on an option it would freeze. Making the group transparent fixed this. Debbie Sent from my iPhone On Oct 7, 2010, at 8:10 AM, "Heenan, Lambert" <Lambert.Heenan at chartisinsurance.com > wrote: > Make sure your error handler includes Application.Echo True > > Otherwise your users will get real confused if any runtime error > happens. > > Lambert > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com [mailto:accessd- > bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan > Sent: Wednesday, October 06, 2010 9:12 PM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Fast clicking > > Just goes to show there is an exception to every rule. > This old dog just learnt a new trick!!!! > > How come I never came across that before? > > :-) > > > -- > Stuart > > On 6 Oct 2010 at 18:11, Dan Waters wrote: > >> 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 >> >> -- >> 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 > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >