AfterRefreshOccurs when ??YYYYYY
BeforeRefreshOccurs when ??YYYYYY

Event Procedures


Before you can use the events you must add a class module and declare a QueryTable object with events

Public WithEvents myQueryTable As QueryTable 

Before the events will run they need to be connected to the corresponding query table object.
This can be done by adding the following code to the class module.

Sub InitQueryEvent(QT As Object) 
   Set myQueryTable = QT
End Sub

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext