Open a file stored in a record

[SeriesIII]

I am playing with an idea for a training database, and want to be able to open video files, the path to which will be stored in a table.

Getting a form to launch Vlc is easy, but how do I modify the code to open a specific file, the patch to which is stored in 'path' in tblFilm?

Private Sub launchMovie_Click()
On Error GoTo Err_launchMovie_Click

Dim stAppName As String

stAppName = "C:\Program Files\VideoLAN\VLC\vlc.exe"
Call Shell(stAppName, 1)

Exit_launchMovie_Click:
Exit Sub

Err_launchMovie_Click:
MsgBox Err.Description
Resume Exit_launchMovie_Click

End Sub


All help appreciated.

 

[pbaldy]

Look at help on Shell; you can specify a file after the exe. You could also use FollowHyperlink.