Play a movie...

[Jim Orson]

Hello,
I have a household inventory database (Access 2007 accdb). In my main form,
I would like to click a button to select a WMV movie file from a drop down
list and have the move run in whatever application the user has registered
to WMV movie files. IOW, selecting a movie in the drop down list would be
equivalent to double clicking the corresponding file in a file manager. The
movies are NOT associated with any particular record and the list of movies
should be the same for any record that happens to have the focus on the
form. How would I accomplish this. I am not a professional programmer...
Thanks!
Jim...

 

[Linq Adams via AccessMonster.com]

You say this is a household inventory database and that the films have no
relationship to any record, so the first question that comes to my mind is
***why*** would you want to do this?

 

[Arvin Meyer [MVP]]

I'm not sure, but this may work for you:

http://www.mvps.org/access/api/api0011.htm

 

[Jim Orson]

You say this is a household inventory database and that the films have no
relationship to any record, so the first question that comes to my mind is
***why*** would you want to do this?

Thanks for your interest Linq. Each record in the db is for a specific item
or small group of related items whereas each movie is a video/audio tour
through a part of the house. It is not necessary to view an entire movie in
order to examine a single record. Any ideas how to accomplish what I
initially described?

 

[Jim Orson]

Arvin, it looks like this code applies to sound files, not WMV video files.
Thanks for your suggestion. Any other ideas? Jim...

 

[Arvin Meyer [MVP]]

Notice it works with AVI files (which are movie files).

If it doesn't work for you, you can try Shelling out to a player:

http://www.mvps.org/access/api/api0018.htm
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Jim Orson]

Arvin, I have no idea where to put this code or how to use it. However I
have devised a way to do what I want to do that is within my pay grade. I
do thank you very much for taking time to respond.

 

[Arvin Meyer [MVP]]

Put either code into a standard Access module which you'll name something
like basMovies (anything but the function names) The just call the code from
a button on a form. For ShellExecute, you'd use:

fHandleFile("C:\FolderName\FileName.wmv",Win_Normal)
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com