VBA PROGRAMMING
Process All Microsoft Access Windows with API Callbacks
Callback functions can let you do things that are impossible from straight VBA code, including accessing every open window (hidden or visible).
Subscribers: Sign-in to activate download link -- Get an example file you can use to follow along with this article.
About this Article:
Ken's previous article in this series, Set Timed Event with Win32 API Callbacks (October 2007), introduced you to the concept of calling Windows API functions that require callbacks, using VBA's AddressOf operator. In this article, you'll investigate a powerful API function that uses a callback function, EnumWindows.
Technical Editor Ken Getz is a programmer, technical writer, educator,
and senior consultant with MCW Technologies. He's a lead courseware
author and presenter, he develops custom Windows and Web applications and tools using Visual Studio and Microsoft Office, and he's been a Microsoft MVP award winner since the program began. Ken is a frequent speaker at Microsoft events, ADVISOR SUMMIT, and other technical conferences. He's co-author of ASP.NET Developer's Jumpstart, Access Developer's Handbook series, and VBA Developer's Handbook. http://www.mcwtech.com/cs/blogs/keng