Is there a way to program the database to open a program called DataLoad (located at "C:\Program Files\DataLoad\DataLoad.exe") and then paste the results of a query in it? The DataLoad program opens and looks very similar to an Excel spreadsheet with the focus in the upper left hand corner.
I would also like to add some code to the database so that it will look and see if a program called Extra or a program called tn3270 is open (these are two MS DOS like, company based, data entry programs). If these programs are not open, the database would just need to pop up a message telling the user that he needs to open one of these programs and sign in before continuing.
Is there any way to do either of these (the first one being the most important)?
Any advice you can provide would be greatly appreciated.
I would also like to add some code to the database so that it will look and see if a program called Extra or a program called tn3270 is open (these are two MS DOS like, company based, data entry programs). If these programs are not open, the database would just need to pop up a message telling the user that he needs to open one of these programs and sign in before continuing.
Is there any way to do either of these (the first one being the most important)?
Any advice you can provide would be greatly appreciated.
