Mobile sex chat club - Access vba stop screen updating

The Go To Control action then moves the focus to the Category ID field, where you can begin to enter data for the new product.

access vba stop screen updating-46

It shows the use of the Echo, Close, Open Form, Set Value, and Go To Control actions.

The Set Value action sets the Supplier ID control on the Products form to the current supplier on the Suppliers form.

This allows you to change the status bar text while the macro runs.

If you turn echo off, you can use the Hourglass action to change the mouse pointer into an hourglass icon (or whatever mouse pointer icon you've set for "Busy") to provide a visual indication that the macro is running.

It's just an idea for you to try, and its effectiveness is pretty dependent on your sheet and calculations.

Specifically, if you are dealing with a User Form, then you might try the Repaint method.

I've found in the many long Excel calculations most of the time waiting is having Excel update values on the screen.

If this is the case, you could insert the following code at the front of your sub: I've found that this often speeds up whatever code I'm working with so much that having to alert the user to the progress is unnecessary.

When the macro finishes, Access automatically turns echo back on and repaints the window.

Tags: , ,