Greetings and win32 com events question

[Robert Kaplan]

Hi,

I'm new to the group, so greetings all!

I'm working on an application try to respond to events in Microsoft
Access using Python and win32com. However, I'm having trouble in
setting up the event handlers. I can think of 2 approaches both of
which yield win32com errors.

First is the approach used the MSOfficeEvents.py test program. The
problem is that the events to be picked up are not on the Application
object but on a Form object created from it.

class AcEvents
def OnActivate(self):
print "Hello from Access"
return 1

<snip>
self. ac = Dispatch ("Access.Application")
self. db = self. ac. NewCurrentDatabase ("d:\\pyhack\\foo")
self. fm = self. ac. CreateForm ()
self. ac. Visible = true
self. fm = DispatchWithEvents (self. fm, AcEvents)

blows out with

self. fm = DispatchWithEvents (self. fm, AcEvents)
File "D:\PYTHON22\Lib\site-packages\win32com\client\__init__.py", line
258, in DispatchWithEvents
clsid = disp_class.CLSID
AttributeError: 'NoneType' object has no attribute 'CLSID'.

I also tried a variety of string arguments, but all of those also
yielded an invalid class id error.

The other approach is more Visual Basic like:

self. ac = Dispatch ("Access.Application")
self. db = self. ac. NewCurrentDatabase ("d:\\pyhack\\foo")
self. fm = self. ac. CreateForm ()
self. ac. Visible = true
self. ev = AcEvents ()
self. fm. OnActivate = self. ev. OnActivate

this couldn't set the OnActivate attribute with the following error.

File "D:\pyhack\1\Bob.py", line 132, in DoAccess
self. fm. OnActivate = self. ev. OnActivate
File "D:\PYTHON22\Lib\site-packages\win32com\client\__init__.py", line
503, in __setattr__
d.__setattr__(attr, value)
File "D:\PYTHON22\Lib\site-packages\win32com\client\__init__.py", line
463, in __setattr__
self._oleobj_.Invoke(*(args + (value,) + defArgs))
TypeError: Objects of type 'instance method' can not be converted to a
COM VARIANT


Anyone know how to do this, either strategy is fine.

Thanks

Robert Kaplan
(Remove XX for e-mail)