Here is a simple way of doing it 1) Create an MS Access macro to run your query and output the result to an external table (DBF, EXCEL, CSV) or to save it as a MS Access table. 2) Write a DOS batch program that calls MS Access. Use the /x switch to call your MS Access macro 3) Have the button in your UI to call the batch program using RunProgram() 4) Use OpenTable() to load the content of the table created in (1)
Armando On Wed, Mar 14, 2012 at 12:15 PM, tracysdfw <[email protected]> wrote: > ** > > > How would one create a script that when the button or box is activated, a > query in ms access is run and the subject is shown on the map? > > > -- Armando Scalise
