Discussion:
screen update
(too old to reply)
mcnews
2011-12-09 21:28:17 UTC
Permalink
is there a way to turn off screen updating till your process finishes?
John W. Vinson
2011-12-10 00:08:51 UTC
Permalink
Post by mcnews
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
2011-12-10 14:52:46 UTC
Permalink
looks like you have leave off the =
but it works.
thanks much!
Tony Toews
2011-12-13 03:14:29 UTC
Permalink
On Fri, 09 Dec 2011 17:08:51 -0700, John W. Vinson
Post by John W. Vinson
Post by mcnews
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.
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
2011-12-13 03:15:09 UTC
Permalink
On Fri, 09 Dec 2011 17:08:51 -0700, John W. Vinson
Post by John W. Vinson
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/
Continue reading on narkive:
Loading...