Ms access screen updating off
Without the checkbox set, you will see the reports open and minimize, in design view. Echo method is simple to use, but many developers miss it, allowing their applications to appear somewhat dizzying as objects appear and disappear from the screen.The acb Show Updates method really doesn't do much besides what a direct call to Application.I always assumed it was just used so that it didn't scare end users into thinking their PC was about to crash.When I started reading more into improving the efficiency of your code I understood what it was for but how much of an effect does Turning off screen updating will only make a difference to execution time if the code interacts with Excel in a way that causes changes to the screen content.The process takes about 2 or 3 seconds, long enough to observe the design view and property box.I think this looks kind of tacky and I would like hide it till it is finished. Well, it was the only way I found to set the rowsource and other properties on the charts in my reports.Try it both ways; you should see a clear difference between the two ways of running the test.With the checkbox set, the underlying code disables screen updates, so you shouldn't see the reports' icons pop up.
And after all don’t turn screen updating on/off many times in some loop. And one more note (which you probably don’t want to hear) if you want it quick use C .The grater the amount of screen changes the bigger the impact will be. Other application settings that can make a difference to execution time are Calculation and Event handling. Enable Events = False ' Code here Clean Up: On Error Resume Next Application. Calculation = xl Calculation Automatic Application. Enable Events = True Exit Sub EH: ' Do error handling Resume Clean Up End Sub Sub test Screen Updating() Dim i As Integer Dim numb Switches As Integer Dim results As String 'swap between sheets this number of times numb Switches = 1000 'keep track of time Dim start Time As Double start Time = Time 'swap between sheets 1/2 (need both sheets or this will crash) For i = 1 To numb Switches Sheets(1 (i Mod 2)).Use this code template as a starting point (the error handler ensures that these properties are turned back on at the end of the sub, even if it errors) Sub Your Sub() On Error Go To EH Application. Select Next i 'get results results = "Screen Updating not disabled: " & Format(Time - start Time, "hh:mm:ss") & " seconds" start Time = Time 'scenario 2 - screenupdating disabled Application. By passing this method a True or a False value, you can indicate whether you want to display updating within the main Access window.The form includes a checkbox that allows you to run the test with screen updates enabled or disabled.