Avi running in access`

[RUDOLFSUN]

Hi i am making a training database for my firm so that new starters can get the basics of acccess quickly. I have a form which displays information called from a table and prints clear instructions in a text box. I have also created some screen movies of me doing basic actions so that when a new user chooses a topic they can also view a movie if they want to. the hyperlink to the movies is also stored in a table, and so when they cloick a start button access should load the movie. The code I am using at the moment works if you put in the movies direct location, but does not work if you ask it to look at the field that contains the hyper link in the table


the code


Dim returnstring As String
Dim erg As String
Dim FileName As String

returnstring = Space(127)
' Me![hrefVideo]" = the field name that contains the hyper link
FileName = "Me![hrefVideo]"
erg = mciSendString("open " & Chr$(34) & FileName & _
Chr$(34) & " type avivideo alias video", returnstring, 127, 0)
erg = mciSendString("set video time format ms", returnstring, 127, 0)
erg = mciSendString("play video from 0", returnstring, 127, 0)


If you can't fix the code, is there any other way I could open an avi in access using a form but so that itlinks to the topic selected in the form

thanks

 

[RUDOLFSUN]

can any body help?

 

[RUDOLFSUN]

I can't believe 39 people have viewed this and not one person can help!!!