Application.ScreenUpdating = False

[Ammarhm]

Hi
I am trying to build a VBA modul, two lines with the command (Application.ScreenUpdating) are returning an error:

Application.ScreenUpdating = False
..
.
. Some code here
.
.
Application.ScreenUpdating = True

THe error is
Compile error, Method or data member not found
Anyone has a clue what the problem is? Maybe something in references?
Regards

 

[thechazm]

It simply means that .ScreenUpdating is not a meathod of application. This could be due to a reference yes but I do not know which one would give you this ability.

 

[boblarson]

ScreenUpdating is in Excel, but it isn't in Access. In Access you would use

Application.Echo False

Application.Echo True