[AccessD] [SPAM SUSPECT] Re: Strange flickering problem.

Bobby Heid bheid at appdevgrp.com
Thu Jan 26 13:40:47 CST 2006


Nope, no timers.  This only happens when you open something else like Excel,
etc., when a long running macro is running.

Bobby

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Murphy
Sent: Thursday, January 26, 2006 2:03 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] [SPAM SUSPECT] Re: Strange flickering problem.


Just a guess but it sounds like a timer is running on a form.  Are there any
forms open when you see this behavior?

Doug

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bobby Heid
Sent: Thursday, January 26, 2006 10:39 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] [SPAM SUSPECT] Re: Strange flickering problem.


Hi Charlotte,

There is no UI, except for the one in Access.  I have the macro open and I
am running it.  This is not always happening and it does not do it if I do
not switch away from Access.  There really is no flickering normally.  By
flickering, I mean EVERYTHING showing from Access is flickering - the
database window, the properties window, the macro window, and anything else
opened in the IDE.

Bobby

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
Sent: Thursday, January 26, 2006 11:31 AM
To: Access Developers discussion and problem solving
Subject: [SPAM SUSPECT] Re: [AccessD] Strange flickering problem.
Importance: Low


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




More information about the AccessD mailing list