By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,758 Members | 1,247 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,758 IT Pros & Developers. It's quick & easy.

MS Access with VB for applications and python

P: n/a

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
Jul 18 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Uggen Kristin T <Kr*************@sintef.no> wrote:

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.
--
- Tim Roberts, ti**@probo.com
Providenza & Boekelheide, Inc.
Jul 18 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.