On 15/04/2015 01:47, Emile van Sebille wrote:
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
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
--
https://mail.python.org/mailman/listinfo/python-list
