is there a way to turn off screen updating till your process finishes?
J John W. Vinson Dec 10, 2011 #2 is there a way to turn off screen updating till your process finishes? Click to expand... Yep. Set Application.Echo = False before your process. Be sure to set it back to True when you're done. -- John W. Vinson [MVP] Microsoft's replacements for these newsgroups: http://social.msdn.microsoft.com/Forums/en-US/accessdev/ http://social.answers.microsoft.com/Forums/en-US/addbuz/ and see also http://www.utteraccess.com
is there a way to turn off screen updating till your process finishes? Click to expand... Yep. Set Application.Echo = False before your process. Be sure to set it back to True when you're done. -- John W. Vinson [MVP] Microsoft's replacements for these newsgroups: http://social.msdn.microsoft.com/Forums/en-US/accessdev/ http://social.answers.microsoft.com/Forums/en-US/addbuz/ and see also http://www.utteraccess.com
T Tony Toews Dec 13, 2011 #4 Yep. Set Application.Echo = False before your process. Be sure to set it back to True when you're done. Click to expand... And in your error handling routine. Tony -- Tony Toews, Microsoft Access MVP Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/ For a convenient utility to keep your users FEs and other files updated see http://www.autofeupdater.com/
Yep. Set Application.Echo = False before your process. Be sure to set it back to True when you're done. Click to expand... And in your error handling routine. Tony -- Tony Toews, Microsoft Access MVP Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/ For a convenient utility to keep your users FEs and other files updated see http://www.autofeupdater.com/
T Tony Toews Dec 13, 2011 #5 Application.Echo = False before your process. Be sure to set it back to True when you're done. Click to expand... Also if you're debugging code and, for example, put a breakpoint, stop or msgbox in the code you might not see anything happen. Tony -- Tony Toews, Microsoft Access MVP Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/ For a convenient utility to keep your users FEs and other files updated see http://www.autofeupdater.com/
Application.Echo = False before your process. Be sure to set it back to True when you're done. Click to expand... Also if you're debugging code and, for example, put a breakpoint, stop or msgbox in the code you might not see anything happen. Tony -- Tony Toews, Microsoft Access MVP Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/ For a convenient utility to keep your users FEs and other files updated see http://www.autofeupdater.com/
