play .wav file

[kapooranuj]

hi all,
please tell how can we play a wav file from a database in VB
i have number of fields in my database including audio. i want that when i press the next button the wav file should automatically jump to next record.

quick please!!

[darre1]

Private Const SND_ASYNC = &H1           'play asynchronously
Private Const SND_FILENAME = &H20000    'name is a file name
Private Declare Function PlaySound Lib "winmm.dll" Alias "PlaySoundA" (ByVal lpszName As String, ByVal hModule As Long, ByVal dwFlags As Long) As Long
 
Private Sub Form_Load()
    PlaySound "[i]FILE.WAV[/i]", ByVal 0&, SND_FILENAME Or SND_ASYNC
End Sub

there's an example