M
mcnews
is there a way to turn off screen updating till your process finishes?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
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
M
mcnews
looks like you have leave off the =
but it works.
thanks much!
but it works.
thanks much!
T
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/
T
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/