Ms access vba turn off screenupdating Busty senior dates

18-Aug-2017 08:41

I added the line "Lock Window Update (0&)" after the "If Lock Window Update(hwnd) = 0"-paragraph, but I couldn't really notice a difference.

Raise Number:=vb Object Error ERR_VERSION_NOT_SUPPORTED, _ Description:="Newer version." Exit Property End Select If hwnd = 0 Then Err.

You can verify that its working though by leaving it set to False. Option Explicit ' User Defined Error codes Const ERR_NO_WINDOW_HANDLE As Long = 1000 Const ERR_WINDOW_LOCK_FAIL As Long = 1001 Const ERR_VERSION_NOT_SUPPORTED As Long = 1002 ' API declarations for Find Window() & Lock Window Update() ' Use Find Window API to locate the Power Point handle.

Private Declare Function Find Window Lib "user32" Alias "Find Window A" _ (By Val lp Class Name As String, _ By Val lp Window Name As Long) As Long ' Use Lock Window Update to prevent/enable window refresh Private Declare Function Lock Window Update Lib "user32" _ (By Val hwnd Lock As Long) As Long ' Use Update Window to force a refresh of the Power Point window Private Declare Function Update Window Lib "user32" (By Val h Wnd As Long) As Long Property Let Screen Updating(State As Boolean) Static h Wnd As Long Dim Version No As String ' Get Version Number If State = False Then Version No = Left(Application. Version, ".") - 1) 'Get handle to the main application window using Class Name Select Case Version No Case "8" ' For PPT97: h Wnd = Find Window("PP97Frame Class", 0&) Case "9" ' For PPT2K: h Wnd = Find Window("PP9Frame Class", 0&) Case "10" ' For XP: h Wnd = Find Window("PP10Frame Class", 0&) Case "11" ' For 2003: h Wnd = Find Window("PP11Frame Class", 0&) Case "12" ' For 2007: h Wnd = Find Window("PP12Frame Class", 0&) Case "14", "15" ' For 2010: h Wnd = Find Window("PPTFrame Class", 0&) Case Else Err.

How can you turn off the flashing screen during macro execution ?

I used this function about 7 years ago and it prevented the user from seeing a bunch of activity while the macro ran.' -------------------------------------------------------------------------------- ' Copyright 1999-2015, Shyam Pillai, All Rights Reserved.