I have a question that I do not even know where to start.
We have a program in my company that runs queries from the backend of the intergrated system. The program is called Showcase.
Currently the procedure is to click on hyperlinks in the access databases to run those queries which opens the showcase application and cues you to enter a password. Then you need to run the query.
There are a few other queries that exsists outside the database, and when click to run it the query opens the application then cues for a password. The difference with this version you do not have to select to run it. I kicks automatically.
I would like to find a way using possibly VBA in my access databases to create sub routine that would kick this program off and auto fill the password. I then would use the scheduled tasks application in my OS to run it without manually kicking it off.
I do appreciate any help.