Sorry Rick, I thought my message would show up under the original. The
questions was: I am using Shell() to run an MS application from Access and
would like to know if there is a way to close that application when it looses
focus (Access gains back the focus).
Participation in these newsgroups is voluntary, both for folks who post and
folks who respond. Sometimes the folks who respond don't know. Sometimes
the folks who do know aren't able to get to the 'groups.
If your need is urgent, consider hiring someone for paid technical
support...
The only question previous to this that I can see now is about Access
training, and that was answered. Newsgroup servers vary, and sometimes
messages take a while to get through
sometimes messages disappear.
I have looked for an answer from a different group to which I posted before
now.
I saw the previous post. Thought it was in another ng.
One other reason that posts don't get answered is that, at the time
someone reads it, they don't want to address it.
Unless you use the Shell and Wait function that you'll find on www.mvps.org/access Access will simply continue on its merry way
after the shell(). I recommend that you open a modal form in the very
next line of code that tells you to wait until you're done with the
other application. When you finish with the other thing. Close the
form et voila!
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
