I am creating an Access database for my extensive DVD collection. Part of
what I want to do is to link movie trailers (on my computer) to the database,
so I can click on the link and autorun the specific trailer. I am thinking I
would like to embed a media player into a form and when the user either
clicks on the trailer link or cmd button programmatically call the form with
the media player and run the clip. Is this doable? Or even, have the media
player on the main page with a datasheet subform below it so the user can
scroll through the movie list. I am still in the design stage and am looking
for functionality, of course if it is super advanced, I may not add it, but
this would make my db unique. Any suggestions on how to go about setting this
functionality up? Thank you for you time on this.

You can simply drop a Windows Media Player activeX control onto your form
and reference its properties through your code tied to the command button or
the datasheet. Set the ShowAudioControls and ShowControls to No so that only
the display shows on the form. Set the FileName property to the media file
you wish to play, then call the Play method of the MediaPlayer object and
that should do it. HTH

LEWIS HANNAH

--

"MSfStl" <(E-Mail Removed)> wrote in message
news:F278A3D1-DD66-403A-9E34-(E-Mail Removed)...
I am creating an Access database for my extensive DVD collection. Part of
what I want to do is to link movie trailers (on my computer) to the
database,
so I can click on the link and autorun the specific trailer. I am thinking I
would like to embed a media player into a form and when the user either
clicks on the trailer link or cmd button programmatically call the form with
the media player and run the clip. Is this doable? Or even, have the media
player on the main page with a datasheet subform below it so the user can
scroll through the movie list. I am still in the design stage and am looking
for functionality, of course if it is super advanced, I may not add it, but
this would make my db unique. Any suggestions on how to go about setting
this
functionality up? Thank you for you time on this.

On Mon, 27 Mar 2006 11:20:01 -0800, MSfStl <(E-Mail Removed)> wrote:

>I am creating an Access database for my extensive DVD collection. Part of
>what I want to do is to link movie trailers (on my computer) to the database,
>so I can click on the link and autorun the specific trailer. I am thinking I
>would like to embed a media player into a form and when the user either
>clicks on the trailer link or cmd button programmatically call the form with
>the media player and run the clip. Is this doable? Or even, have the media
>player on the main page with a datasheet subform below it so the user can
>scroll through the movie list. I am still in the design stage and am looking
>for functionality, of course if it is super advanced, I may not add it, but
>this would make my db unique. Any suggestions on how to go about setting this
>functionality up? Thank you for you time on this.

Here's the link to MS site for Media Player:

http://www.microsoft.com/windows/win...erforpros.mspx

There's links there to the MSDN center, which should provide you with plenty of hours of reading pleasure <g>. I didn't
see in the documentation where MS claims that it's suitable for use in Access, but I didn't dig too deep either.

Here's a freeware control that claims to work in Access:

http://www.newfreeware.com/development/421/

can't speak for it as i've never used it

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com