Where are Access Application Events?

Y

Yazeed

Hi All,

I have been working in automating Excel,Word and powerpoint 2007 using
Office PIAs for a while, i need to automate MS Access 2007 as well.

Now, in other office products i worked with, the Application object has
several events you can trap like BeforeClose, WorkbookOpen,
DocumentOpen,etc.......

I dont seem to find any event in Microsoft.Office.Interop.Access.Application
object.

can anybody please point me how to trap those events??

Thanks in advance
 
A

Arvin Meyer [MVP]

I think the only application events are the AutoExec macro and AutoKeys
macro. Other application wide code is run from or called standard modules.

Access responds to form and report events. There are more than 50 events for
forms, plus events for sections of forms and dozens of events for controls
on forms. Each event can call events on other forms or from other databases
as well as code from standard modules, both in the current database, or in
other databases.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top