Working with Access tables and python scripts
Mark Lawrence
breamoreboy at yahoo.co.uk
Tue Apr 14 22:23:58 EDT 2015
On 15/04/2015 01:47, Emile van Sebille wrote:
> On 4/14/2015 3:20 PM, accessnewbie at gmail.com wrote:
>
> > I have an existing extensive python script that I would like
> > to modify slightly to run a different variation on a process.
> >
> > I also have all the variables I need to run this script (about
> > 20 in total)stored in an Access 2010 64 bit database.
> >
> > Is it possible to create a button on an Access form (or other GUI)
> > to pass the information that is stored in the various fields in the
> > database to the python script? Not all the values are in a single
> > table.
> > A query joining related tables would need to be done. Ideally I would
> > like to execute the script from the Access data entry form
> > immediately after entering the required data into the database.
>
> Yes -- I did so in excel using VB some 15 years ago. Download and
> install Mark Hammond's win32 extensions. I don't off the top of my head
> remember the details, but if no one else chimes in I could probably
> dig out that code.
>
> Emile
People can always ask here
https://mail.python.org/mailman/listinfo/python-win32 also available as
gmane.comp.python.windows
--
My fellow Pythonistas, ask not what our language can do for you, ask
what you can do for our language.
Mark Lawrence
More information about the Python-list
mailing list