Executing apps outside of Access
I have an auto grading examination form. Recently, I added a countdown timer which ultimately will warn the student when there are two minutes left and save and exit the exam when time runs out. For the two minute warning I have been using the "Beep" from Access. I would like to know how to execute a .wav file from code. Is the Shell command the way to go or OLE. I can create a batch file but that's a little sloppy. This is the gist: The following example tests a 25 second timer value at zero. (The beep works, but I'm stuck on the Shell part. I liked the Shell idea so I can run the app either minimized or hidden.)
If (25 - Seconds = 0) And (99 - MilliSec = 0) Then
TimerInterval = 0
Any input on Shell or alternative methods would be appreciated.
Dave Mack Saratoga, NY