Solved: Possible to disable screen updating for Access?

[herzberg]

Hi all,

Just a quick question here. Is there a setting or Excel equivalent of ScreenUpdating property within Access that I can set to disable screen updating? I have this macro that deletes and importing multiple tables and the flickering kinda irritates me. My users love it though; it's the only proof to them that the macro is actually working.

[Oorang]

For Access Macros, you will want:

SetWarnings (Supresses all those "Are you sure messages.")
Hourglass (Set the mouse to an hourglass.)
Echo (Disables screen updating and puts messages in the status bar.)For Access VBA just prefix those with DoCmd (Ex: DoCmd.HourGlass)

[CreganTur]

Just a cautionary note: if you use DoCmd.SetWarnings False to turn off all of the "are you sure warnings"

Be certain that you place a DoCmd.SetWarnings True just before your End Sub (or somewhere in your code) so that the warnings are re-instated when you're done.

[Oorang]

Good point! :)

[CreganTur]

Thanks- learned that the hard way. Not an error I want other people to have to go through!

[herzberg]

Thanks a lot guys!

[Trevor]

awww... who needs warnings? :Beerchug: they just get in the way end users love 'em for some unknown reason, the more the better :-p