Charlotte Foust
cfoust at infostatsystems.com
Thu Jan 26 10:30:57 CST 2006
In my experience, the IDE does tend to flicker when intense execution is going on, because focus is shifting back and forth from the IDE to the UI. Why have the IDE open at all if you're running macros? All you need for that is the interface and you can build one or more macros to call other macros, so it's not really necessry to use the immediate window. Charlotte Foust -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bobby Heid Sent: Thursday, January 26, 2006 8:19 AM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Strange flickering problem. Hey, Doing some work on-site for a client using Access 2000. I am updating an existing reports database that uses mostly macros to call queries and what-not. They want me to do the same (ughhh!). The OS is XP Pro. Their are local tables and links to SQL tables in the database. Anyway, sometimes when I kick off a long running macro (5-10 minutes), and go to do something else, Excel, email, etc., when I come back to the Access IDE, it will be flickering very badly. Through task list, I see 100% CPU, with Access taking maybe 50% and explorer taking up most of the rest. I have not left it more than about 15 minutes before killing Access. Task list shows Access as running during this. After killing Access the system is back to normal. It looks like something is making all of the windows redraw hundreds of times a second. Even the task list wind (set to on top) flickers some. Has anyone else seen this? Have any solutions? Thanks, Bobby -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com