Rocky Smolin at Beach Access Software
rockysmolin at bchacc.com
Mon Dec 31 11:20:42 CST 2007
JC: Fortunately for this form - no subforms. Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Monday, December 31, 2007 9:03 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Screen Flutter Rocky, The thing to remember is that the subforms open and populate before the main form. You might try doing the same kind of thing inside each subform and see what happens. John W. Colby Colby Consulting www.ColbyConsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at Beach Access Software Sent: Monday, December 31, 2007 11:43 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Screen Flutter Dan: Thanks. That knocked the flutter down to 2. Regards, Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters Sent: Monday, December 31, 2007 7:58 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Screen Flutter Hi Rocky, The cause is indeed the requeries. The solution is to use Application.Echo False [Opening Code] Application.Echo True A caveat: If you are going to use this in production code, you must introduce error trapping into every procedure that could possibly be used during startup, and that error trapping must include the line: Application.Echo True I error trap every procedure, and include this line in every trap. Another caveat: While you are developing, if you have an error and you have error trapping turned on, then you will get a frozen screen and will need to End the app with Task Manager. Hope this Helps! Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at Beach Access Software Sent: Monday, December 31, 2007 9:19 AM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Screen Flutter Dear List: Legacy app. Continuous bound form with no sub-forms. When it opens it 'flutters' I guess what we always call here the 'flashing screen' phenomenon. It flashes or flutters 3-5 times during opening. There are a bunch of requeries and a couple of repaints in the code but that's not causing it because I comment them out one at a time and saw no change. Tried Me.Visible=false on entering the open event and Me.Visible=True before leaving the open event. No difference. So what's the most likely cause of the fluttering or flashing on open? MTIA Rocky -- 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 No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.516 / Virus Database: 269.17.12/1203 - Release Date: 12/30/2007 11:27 AM -- 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 No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.516 / Virus Database: 269.17.12/1203 - Release Date: 12/30/2007 11:27 AM