Solved

MS Access ScreenUpdating = false?

Posted on 2008-06-19
1
812 Views
Last Modified: 2013-11-28
In  Excel I can "freeze" the appearance of the window while a macro runs in the background updating various cells in a spreadsheet and then "unfreeze" the screen to reveal all of the changes. Do this eliminates screen flicker and other various unattractive visual actions while a macro is running.

Can the same thing be accomplished in MS Access? I have a couple of subforms that require my using Me.Requery to get data content up-to-date after a user enters some data. Unfortunately, I'm seeing some weird data momentarily appear in the subform that eventually disappears after the Me.Requery completes.

Is there a way to "freeze" the display of MS Access until the Me.Requery finishes?
0
Comment
Question by:GRIPA1
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 77

Accepted Solution

by:
peter57r earned 250 total points
ID: 21824978
Application.echo false  
(or True to turn it back on)
0

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

732 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question