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

But I have no form open, just running a macro from the database window.  It
is only updating tables.

Thanks,
Bobby

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


There is something about turning screen.update on and off.
(True/False)

Try calling some form.
Screen.update = false
Run Macro
Open proper form
Screen.update =  true

Joe Hecht
jmhecht at earthlink.net
-----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