Unanswered: Opening an MS DOS command prompt within the code.
Guys, any idea how I can use Access VBA (and it has to be VBA and not a macro) to open an MS DOS command prompt from within a form?
What I'm really trying to do is use a net send to warn me of an error, but I can't seem to get the SendKeys method to send either a Windows Key or a Ctrl & Esc at the same time. This means I can't get at the run prompt.
Therefore option 2 is to open an MS DOS window and then use SendKeys to send the string and the enter key to send me the message.
Will also need to know how to shut the prompt window down afterwards, if you can also let me know.