Disable screen updating access vba americasinglescommunity dating sites

07 May

Check out Got a version of Word that uses the menu interface (Word 97, Word 2000, Word 2002, or Word 2003)? If you use a later version of Word, visit our Word Tips site focusing on the ribbon interface.

Using Access 2007 and VBA, I have a few forms which seem to flicker for some unknown reason. The user would select a date by clicking the corresponding toggle button.

This means that the Word screen can look like it has "gone crazy" while the macro is running.

One thing you may want to do with your macro to make it run faster and to prevent distracting flashes on the screen is to turn off screen updating while the macro is running.

The idea is to use the first line near the beginning of your macro, and then use the second line near the end.

Allen Wyatt With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. Quickly teach yourself how to format, publish, and share your content using Word 2013.

He is president of Sharon Parq Associates, a computer and publishing services company. With Step by Step, you set the pace, building and practicing the skills you need, just when you need them!

Value = "Showing pictures for the " & Format Ordinal(Format(Selected Date, "d")) & " of " & Format(Selected Date, "mmmm yyyy") With rs . Move First i = 1 j = 0 While i Have you tried setting echo off at the beginning of your procedure to turn off screen repainting and on again at the end of the procedure? Mary" id="ctl00_m_m_i_ctl00_gr_ctl01_bestanswerbody" class="textarea-bestanswerhidden" name="bestanswerbody" answerbody Id="3898443" / Hi Matt Have you tried setting echo off at the beginning of your procedure to turn off screen repainting and on again at the end of the procedure? Mary As Mary has suggested, the simplest way to prevent the flickering is to use the Application.

Echo true If you do this you need to have good error trapping set up that returns you to a point in the code that sets the echo back on and best to do this after you have debugged the code. Echo true If you do this you need to have good error trapping set up that returns you to a point in the code that sets the echo back on and best to do this after you have debugged the code.