Stop the screen flashing while running a string of queries 2

[bxgti4x4]

Is there a code which you can enter before a series of queries are run which will stop the results of each action flashing up on the screen?

Ideally I would like the screen to display just a rotating hour glass or similar whilst the code is being run.

Best Regards
John

 

[PHV]

Perhaps the Application.Echo method ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[jimlee]

docmd.hourglass true
docmd.echo false

code here

docmd.echo true
docmd.hourglass false




jimlad

 

[bxgti4x4]

PHV/Jimlee

Thanks guys, the Application.Echo method worked fine. I didn't need the hourglass as the whole code ran so much quicker.

Best Regards
John