Ms access turn off screenupdating

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

The No setting for the Echo On argument doesn't affect the functionality of the macro or its results.

it doesn't stop execution of any other code, like a modal userform would).

You could just make the label display a message like 'Pleaes wait...', but if you are iterating through a list or number of records or something, you could use the label to update the number of records or the name of the current record for example.

To run the Echo action in a Visual Basic for Applications (VBA) module, use the Echo method of the Do Cmd object.

The following macro opens the Add Products form from a button on the Suppliers form.

Leaving warnings off will prevent Access from warning you that there are unsaved changes should you modify something and forget to save it. If you want to display a messge rather than an hour-glass, here is a method I use a lot in Excel that I'm sure would work in MS Access. Just before you need to use it, display the userform using: This will ensure the userform is running modless (i.e. Make sure the 'Show Modal' property is equal to False.When automating actions in Microsoft Access such as running Action queries, you may wish to avoid any user intervention, for example having to OK warning messages when running an Update, Make-Table, Delete or Append query.If we run this type of query, without turning off the system messages, the user will be prompted to OK any actions that occur.

Leave a Reply