Make sure you Check Mark it then select the OK button to exit the References Window. Scroll down the list of different references until you see the Windows Media Player reference (near the bottom). When in the Code Editor, simply select the Tools Menu then select References. To play Audio files you do not need to place the Media Control itself into your Form but you do need to Reference the Window Media Player OCX through the References Window located within the VBA IDE (VBA Code Editor). The sample DB's provided will play those files but now I am getting the impression that what you really want to do is display Video files as in video clips etc. To make sure one thing is clear here, a WMA file is a Audio file. In your first post you indicated that you wanted to play a. You will benefit by doing so in the future should you ever need to look back upon your code.
Try to understand it just a little bit more. I had provided you with a simple sample that demonstrates all the above items ease look at the code a little closer. You do not need the ay which for clarity should really be in your case,. The Media Player will automatically start to play the file. If you just want the running Database File Name then you can use:īottom line.you need to tell the Media Player control exactly where to find the file to play.Īnother thing you should be aware of is, when you provide the Url to the Media Player Control as in: In the case of our example this would be: This will return in a Message Box the Path and File Name of your running Database.
If you wanted the Path and File Name of your running Database then you could use:
For example, if your Database name is MyDB.mdb and it was located on Hard Disk Drive E: in the Folder named MyDatabases then the property will provide this when used: The is a internal Microsoft Access property that returns the Path location of the Database (your database) which queried it. If the file.wma file is located in the same location where your MS-Access Database is located (the database running this code) then you need to tell the Media Player that as well by using this sort of method: If the file.wma file is located in the Root directory of Hard Disk Drive C then the Media Player control needs to be told that. Yes, you specified the file name but you did not tell the media player where to find the file. You did not specify a Path to the file file.wma. The Error displayed to you is indeed correct in this case.
0 kommentar(er)
