Go Back   Access World Forums > Microsoft Access Discussion > Modules & VBA

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 03-28-2000, 07:57 AM   #1
David Mack
Senior Member
 
Join Date: Jan 2000
Location: Saratoga, NY
Posts: 53
Thanks: 0
Thanked 0 Times in 0 Posts
David Mack
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
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

David Mack is offline   Reply With Quote
Old 03-28-2000, 11:46 PM   #2
Travis
Registered User
 
Travis's Avatar
 
Join Date: Dec 1999
Location: Kingsburg, CA, USA
Posts: 1,332
Thanks: 0
Thanked 1 Time in 1 Post
Travis is on a distinguished road
I would insert an OLE Wave Sound Object on to the Test Form. and set its Action Property as required.
__________________
Travis L Abrahamson

Travis is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump




All times are GMT -8. The time now is 10:36 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World