April 10th, 2009, 02:54 PM
"Access"ing Application Events (Get it???)
So this is a VBA question, not technically 6.0 but similar enough. I am working on an Access 2003 Database and would like to have access to the Application events. In other Office 2003 Applications, I create an event class module and place a reference to the application in that class, that class then can handle the events from the Application.
However, in Access 2003, I used a similar setup and nothing. In the drop down box for the objects of the class, my Access Events Object is not showing up. So far the only thing in this class I am creating is the definition as follows.
Public WithEvents objAccessEvents As Access.Application
In Word and Excel this is enough to let me get access to the application events and write handlers.
Anyone have any idea?
Tags for this Thread
Click Here to Expand Forum to Full Width