video materials database (urgent) (1 Viewer)

[shery123]

hi all ,
i make a database of video materials and pdf notes of some subject. it has a table called Materials , this table has the following fields:
1-material_ID (autonumber)
2-material_Name(text)
3-material_Video(attachment)
4-material_PDF(attachment)
and i have a form that has a combox of matrial_name list shows the name, material video and material pdf field . then i put a button and an activeX media player control , such that when i click this button it plays the video in this activeX wmplayer control.
i tried " material_video".fileURL but it returns nothing so the wmp doesn't play the vido.
how to solve this problem.... any other ideas are welcomed to play this video.
thanks in advance,

 

[boerbende]

Can you use VBA?
I am using Windows to start the appropritate program by


Filename = C:\YourDirectory\yourfile
Shell "C:\WINDOWS\explorer.exe """ & Filename & "", vbNormalFocus

Now it does not matter what yourfile is. When Windows knows the extension, it will start the file

 

[shery123]

thanks bro ,
windows media player active control in ms access needs a specific URL of the video file to play it. first i thought to make a field named " VideoURL " and insert in it every url for all of my video but i have alot of them so i found it not reasonable solution ... now i am searching for a property of the attachment field to retrieve it url to use it for the wmp activex control in the ms access form

 

[Ari]

Hi

Use the SaveToFile method to extract video from your attachment field. Use the extracted file in the url

https://msdn.microsoft.com/pt-br/library/office/ff191852(v=office.15).aspx

 

[shery123]

thanks Ari , i will try it , but after english translation