Working with Access tables and python scripts

[Emile van Sebille]

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