In my DBase Ive got a need to hide the screen changes from the user, does anyone know if its possible in Access ..Ive looked over the help in access(2003) and cannot find it, there is a command it excel "Application.screenupdate = true" and False to disable, Can this be done is ACCESS, ive used the docmd.setwarnings = False and then true, but I cannot stop the screen moving, Thanks.. The Echo method specifies whether Microsoft Access repaints the display screen. Echo True Very important to unfreeze the screen if an error occur...Go To What:=wd Go To Bookmark, Name:="Last Position" Active Document.Since their values never change, they are evaluated only once when your code is compiled, rather than each time they are used at run time.This is closely tied with Specific Object Type Declaration.This page lists some suggestions and strategies for optimizing your Visual Basic For Applications (VBA) code, so that it will run faster.There are few absolute rules for optimizing VBA; you'll see the best increases in performance by streamlining the basic logic.
else it will LOOK AS IF the whole thing is frozen, when it is only the painting which is off. Hoping it may help, Vanderghast, Access MVP Hi, Then, you can try the API function Lock Window Update.Finally after a year and a half, [my husband Reggie, who is also a writer, and I] felt it was good enough and went out with it.And I kept getting the feedback that it was “too soft,” which I just didn’t know what that meant, how is it soft? Dimensional [email protected] I welcome e-mail messages, please post all thread activity in these forums for the benefit of all members.I've emailed instructions to Mike on how to clean up his hard drive and told him to then run the code again.At what point do you begin processing the Print command?