Vocabulary Project

[Mina Garas]

Hi Everybody

I want to make a Vocabulary Project using access
i already made a table consist of 3 fields
first filed name is Word
second field name is Definition
third field name is pronounce

i want put "pronounce" sound file in the third file so that
the user can listen to the word pronunciation when he press on the field

my question is how i can put that sound file in my table

thanks

[burrina]

Yes, you can, well, you need a module and some code to make it happen.
Put this code into a module and save as PlayWavFile Then use this code to fire the wav file: PlaySound ("C:\Sounds\authorization.WAV")
Option Compare Database

Public Declare Function sndPlaySound Lib "winmm.dll" _
Alias "sndPlaySoundA" (ByVal lpszSoundName As String, _
ByVal uFlags As Long) As Long


Sub PlayWavFile(WavFileName As String, Wait As Boolean)
If Dir(WavFileName) = "" Then Exit Sub ' no file to play
If Wait Then ' play sound before running any more code
sndPlaySound WavFileName, 0
Else ' play sound while code is running
sndPlaySound WavFileName, 1
End If
End Sub


Sub TestPlayWavFile()
PlayWavFile "c:\Trakker\authorization.wav", False
MsgBox "This is visible while the sound is playing..."
PlayWavFile "c:\Trakker\authorization.wav", True
MsgBox "This is visible after the sound is finished playing..."
End Sub

[Mina Garas]

thanks alot for your help
but i want ask u about third field data type, is it must be an ole object or another type ???

[burrina]

NO. ONLY a wav file.