Darryl Collins
darryl at whittleconsulting.com.au
Wed May 23 00:39:32 CDT 2012
Yep, Sorry, I knew it wasn't about VBE Flicker - that was just what comes up on the link, it was the fact that Chip lists many ways of manipulating code with code on that site. It has an Excel Focus of course, but I have found it very useful in the past as it at least gets me very close if I am doing stuff in Access - usually close enough to stumble thru the missing bits. Half the time I don't even know the question, let alone the answer. Chip often helps me define the question more clearly. Hope it can help you out. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin Sent: Wednesday, 23 May 2012 3:33 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Jumping Screen Fix - now I know how but not why Not eliminating the flicker during VBProject Code - that's not exactly the problem here - it's the forms flickering, not the code IDE. But the one about Creating an Event Procedure is good. I can loop through all the Forms inserting the Resize event. Thanks Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darryl Collins Sent: Tuesday, May 22, 2012 9:48 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Jumping Screen Fix - now I know how but not why This is for Excel, but it may point you on the right path at least Rocky... << http://www.cpearson.com/excel/VBE.aspx>> -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin Sent: Wednesday, 23 May 2012 2:04 PM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Jumping Screen Fix - now I know how but not why Dear List: As you know I have been struggling with the problem of the 'jumping screen' in a 2003 mde when a form opens. After trying many things to analyze the problem and fix it, I finally hit upon adding DoEvents in the Resize event of every form, and that appears to have solved the problem. So that's the how to fix it, but why I don't know. I'm just curious - does anyone have any insights? So the fix is in on version 23. Unfortunately I am now working on version 24 so I have to insert DoEvents into all of the forms - and there a lot of them. Does anyone have a snippet of code that would insert the event in every form? Or a site where I might find such a piece of code? MTIA Rocky Smolin Beach Access Software 858-259-4334 www.bchacc.com <http://www.bchacc.com/> www.e-z-mrp.com <http://www.e-z-mrp.com/> Skype: rocky.smolin -- 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