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?
April 10th, 2009, 03:42 PM
Re: "Access"ing Application Events (Get it???)
I have found that the Access 2003 events are not available for automation. I know for start up you can use an AutoExec Macro, I'll just have to see if there are any other macros out there that run automatically like that.
Tags for this Thread
Click Here to Expand Forum to Full Width
This is a Codeguru.com survey!