Executing apps outside of Access (1 Viewer)

David Mack

Registered User.
Local time
Today, 19:06
Joined
Jan 4, 2000
Messages
53
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
Beep
'Shell ("C:\WINNT\Media\Office97\Drumroll.wav")
'Shell ("C:\WINNT\Media\Office97\Glass.wav")

End If

Any input on Shell or alternative methods would be appreciated.

Dave Mack Saratoga, NY
 

Travis

Registered User.
Local time
Today, 11:06
Joined
Dec 17, 1999
Messages
1,332
I would insert an OLE Wave Sound Object on to the Test Form. and set its Action Property as required.
 

Users who are viewing this thread

Top Bottom