Disable ScreenUpdating

[Evagrius]

Hi All,

I have a module in my Access Database that opens Excel and runs an Excel Macro.

As it stands now, the user can see Excel opening / closing. I don't want the user to see this. In Excel there you can use appliction.screenupdating = false to prevent this type of thing.

I can't find anything similar in Access. I tried the application.Echo false, but that didn't work and in fact seemed to freeze my Database.

Can anyone please adive? Thank You!

 

[boblarson]

Application.Echo is the method for Access. You set it to False for it to not change anything on screen until you set it back to True.

And depending on how long your item takes it can appear to freeze your database. So it isn't good to use with long running items. Things like changing the recordsource on a subform or a bunch of control labels would be something you might want but running a large query, no.

 

[Evagrius]

Hi Bob - I suppose I am stuck with this issue then. I used it appropriately, but I still see Excel Running. Also, when I use it, for some reason, I can't return to Access from the VB editor - I have to force shut the DB and then reopen. . .

 

[boblarson]

When you say - "but I still see Excel Running" that confuses me. If you don't want Excel to update you would use your Excel Application Object and set it, not Access.

objXL.ScreenUpdating = False

or if you don't want to see Excel at all until you're done, keep it invisible by not setting the visible property to true until done.

If you are not using Excel Automation code and instead are using something like TransferSpreadsheet or OutputTo, then you are stuck with not being able to do any of this.

 

[Evagrius]

Bob - You Are The Man Good Sir!!! Your suggestions did the trick!! Thanks!!