playing a wav. file from within a table

[martin tudge]

dear all
I have been working on a trying to play a wave file
which is embedded as a record in my table as a jingle
when my database opens.
I started (with help from this forum) writing a module to
play the sound file, but the file existed outside the
database on my c drive. What I need is to play the file
from within the database.
Any Offers?

 

[Arvin Meyer]

You can't really do this from a table because you can't run code from a
table. You can use a startup form and run your code from there. Have a look
at the following which will allow you to play any sound or .avi file:

http://www.mvps.org/access/api/api0011.htm
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Douglas J. Steele]

Sorry to quibble, Arvin, but that code allows you to play a .WAV file, not
to play a BLOB representing the .WAV file from an Access table, which I
believe Martin is looking to do. I'm sure it's possible, but I haven't
managed to yet.

 

[Dirk Goldgar]

Sorry to quibble, Arvin, but that code allows you to play a .WAV
file, not to play a BLOB representing the .WAV file from an Access
table, which I believe Martin is looking to do. I'm sure it's
possible, but I haven't managed to yet.

How about using code like that Larry Linson uses in his Image-Handling
sample database ( http://accdevel.tripod.com/imaging.htm ) to extract
the blob to a temporary file, and then use the API code to play that
file?