screen update

[mcnews]

is there a way to turn off screen updating till your process finishes?

 

[John W. Vinson]

is there a way to turn off screen updating till your process finishes?

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

 

[mcnews]

looks like you have leave off the =
but it works.
thanks much!

 

[Tony Toews]

Yep. Set

Application.Echo = False

before your process. Be sure to set it back to True when you're done.

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/

 

[Tony Toews]

Application.Echo = False

before your process. Be sure to set it back to True when you're done.

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/