Word vba screen updating

While opening consecutively opening all forms (translation functionality), the screen keeps flashing.

The Set Warning or Echo methods of the Do Cmd object seem to have no effect.

Echo True Very important to unfreeze the screen if an error occur...

This can mean that what should take a matter of 1 to 3 seconds, often takes a lot longer.

Open Form str Form Name, ac Design, , , , ac Hidden Call List Controls(obj, rds, str Form Name, str Language) .

Set Warnings True End With Hi, You can use Application. Here the Declare statement you need in the declaration portion of the form: Private Declare Function Lock Window Update Lib "user32" Alias "Lock Window Update" (By Val hwnd Lock As Long) As Long Then, use Lock Window Update as if it was a function. On Error Goto Unfreeze Lock Window Update Access App ...

Raise Number:=vb Object Error ERR_NO_WINDOW_HANDLE, _ Description:="Unable to get the Power Point Window handle" Exit Property End If If Lock Window Update(hwnd) = 0 Then Err.

Hence I created this generic wrapper to lock the window updates.

Give it Acess App as argument to freeze, 0 to unfreeze.

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.

If this does happen, you may need to repeat the line: Application.

Screen Updating = False in other parts of your macro. Convert Excel Spreadsheets To Webpages | Trading In Excel | Construction Estimators | Finance Templates & Add-ins Bundle | Code-VBA | Smart-VBA | Print-VBA | Excel Data Manipulation & Analysis | Convert MS Office Applications To......

Leave a Reply