A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Play a movie...



 
 
Thread Tools Display Modes
  #1  
Old October 10th, 2009, 12:32 AM posted to microsoft.public.access.forms
Jim Orson
external usenet poster
 
Posts: 19
Default Play a movie...

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...

  #2  
Old October 10th, 2009, 02:50 AM posted to microsoft.public.access.forms
Linq Adams via AccessMonster.com
external usenet poster
 
Posts: 1,474
Default Play a movie...

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?

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via http://www.accessmonster.com

  #3  
Old October 10th, 2009, 04:01 AM posted to microsoft.public.access.forms
Arvin Meyer [MVP][_2_]
external usenet poster
 
Posts: 2,310
Default Play a movie...

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

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


"Jim Orson" wrote in message
...
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...



  #4  
Old October 10th, 2009, 04:27 AM posted to microsoft.public.access.forms
Jim Orson
external usenet poster
 
Posts: 19
Default Play a movie...

"Linq Adams via AccessMonster.com" u28780@uwe wrote in message
news:9d5c644b77345@uwe...
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?

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via http://www.accessmonster.com


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?

  #5  
Old October 10th, 2009, 04:29 AM posted to microsoft.public.access.forms
Jim Orson
external usenet poster
 
Posts: 19
Default Play a movie...

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]" wrote in message
...
I'm not sure, but this may work for you:

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


"Jim Orson" wrote in message
...
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...





  #6  
Old October 10th, 2009, 03:30 PM posted to microsoft.public.access.forms
Arvin Meyer [MVP][_2_]
external usenet poster
 
Posts: 2,310
Default Play a movie...

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" wrote in message
...
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]" wrote in message
...
I'm not sure, but this may work for you:

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


"Jim Orson" wrote in message
...
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...







  #7  
Old October 11th, 2009, 12:16 AM posted to microsoft.public.access.forms
Jim Orson
external usenet poster
 
Posts: 19
Default Play a movie...

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]" wrote in message
...
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" wrote in message
...
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]" wrote in message
...
I'm not sure, but this may work for you:

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


"Jim Orson" wrote in message
...
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...








  #8  
Old October 11th, 2009, 03:16 AM posted to microsoft.public.access.forms
Arvin Meyer [MVP][_2_]
external usenet poster
 
Posts: 2,310
Default Play a movie...

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_Norma l)
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"Jim Orson" wrote in message
...
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]" wrote in message
...
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" wrote in message
...
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]" wrote in message
...
I'm not sure, but this may work for you:

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


"Jim Orson" wrote in message
...
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...










 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:55 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.