CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2008
    Location
    Appleton, WI
    Posts
    23

    "Access"ing Application Events (Get it???)

    Okay,

    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?

    Thank you

  2. #2
    Join Date
    Jul 2008
    Location
    Appleton, WI
    Posts
    23

    Re: "Access"ing Application Events (Get it???)

    Okay,

    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.

    Thank you,

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  





Click Here to Expand Forum to Full Width

Featured