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

Just a SWAG, if running WinXP change your theme by right-clicking your 
Windows XP desktop,
choosing Properties, and setting the Theme to "Windows Classic".

Bobby Heid wrote:

>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
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada