?
Solved

MS Access ScreenUpdating = false?

Posted on 2008-06-19
1
Medium Priority
?
822 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 1000 total points
ID: 21824978
Application.echo false  
(or True to turn it back on)
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

765 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