On 4/14/2015 3:20 PM, accessnew...@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 -- https://mail.python.org/mailman/listinfo/python-list
