MS Access with VB for applications and python

[Uggen Kristin T]

For the first time, I am trying to program python in a windows-environment,
and now I am having some trouble with combining python and MS Access...

This is what I want to do:
A MS Access database is started, this database has numerous VB-forms, and
one of those forms calls my python-program, so far so good. But before my
python-program quits, I want to call one of the VB-forms in the database.
This I haven't been able to find out how to do.
The database cannot be closed, it has to run all the time while my
python-program is working.

So, if anyone can help me with this, I'll be very happy!

Kristin

 

[Tim Roberts]

For the first time, I am trying to program python in a windows-environment,
and now I am having some trouble with combining python and MS Access...

This is what I want to do:
A MS Access database is started, this database has numerous VB-forms, and
one of those forms calls my python-program, so far so good. But before my
python-program quits, I want to call one of the VB-forms in the database.
This I haven't been able to find out how to do.

Do you mean you need to DISPLAY an Access form, or do you mean you need to
call a function in the associated code module?

The first can be done, by using the Access object model. The second is
more difficult. Access code modules are not COM objects, so you cannot
call directly into them from outside of Access.

However, through the object model, you should be able to use DoCmd, and
that lets you call a macro or a public function.

The Access object model is discussed on Microsoft's web site.