Access Newbie wrote: > Is it possible to transfer the results of an Access 2010 query (accdb > extension) to a python script with the click of a button? Information > will be used as variables within the script. > > Prefer to click button from Access data entry form to execute script > but it can be from another GUI if necessary. > > Data getting transferred (anywhere from 20-50 fields) will be contact > information, shapefile name and directory location, and arcpy > parameters such as buffer distances for various geoprocessing > applications. Script can be run from the command line and does not > require ArcMap to be open to run.
Well, wait a minute. You have described several completely different approaches here. Are you talking about something that runs inside of Access, or a GUI app that talks directly to the database, or a command-line app that pulls from the database? In order to display an Access form, the Access application has to be running. In that case, buttons can call Visual Basic scripts, and it may be easier to do what you want entirely in Visual Basic. There are several ways for a standalone application to talk to an Access database, assuming Access is installed. However, if Access already has the database open, you can't necessarily open it in another application at the same time. -- Tim Roberts, t...@probo.com Providenza & Boekelheide, Inc. _______________________________________________ python-win32 mailing list python-win32@python.org https://mail.python.org/mailman/listinfo/python-win32