Displaying movies within a form

[oreganr]

Hi,

I am new to Access, I have figured out how to play a short movie file using a form, by inserting an ActiveX control of 'Windows Media Player 7' then in the properties, changing URL to point to "C:\Documents and Settings\user1\Desktop\snowflake.wmv"

This is great I can now watch a short 30 secs movie..

What I want to achieve:
I am a student making animations for my art and design course at college.

Everyday I make three to ten short 30 sec annimations, and I make some brief notes on on each animation and say good points and points to improve for future..

Ive been doing this for the last 2 months..and have over 100 mini animations..

Rather than just watch them by clicking on the file in 'My Computer', I want to use Access to make a form, so I can select any day, and watch any of the animations I made that day, and view the comments I made..

That's it, quite simple..

Does this make sense?

e.g. suppose I have 3 movies:
c:\Animation\snowflake.avi
c:\Animation\captaintrek.avi
c:\Animation\stoneguy.avi

Instead of having the URL fixed, how can I make the URL point to a field in a table, and user can select which animation movie to watch on any day ?

Any help would be so much appreciated

Kindest Regards
Ric

 

[CEH]

Try this out.....
http://www.access-programmers.co.uk/forums/showthread.php?t=181273&highlight=image
It was designed for photos, but shouldn't be that much trouble to convert to movies.
At least give you something to build on.

 

[oreganr]

Great, thankyou I will take a look at that..

 

[oreganr]

Ah annoying, Im still waiting for the attachments to get 'approval' its says they are pending.. ok, I'll just have to be patient

 

[oreganr]

AH..!!! This has been waiting for approval for a whole month!!!
Thats really slow.. not sure whats happening here..

Mate, please could you, or anybody else, explain basic code I need to write eg in field 'URL'.. or how I use tables to select from a number of videos?

Its would be so helpful,
many thanks guys.
Rich

 

[boblarson]

I just sent a note off to the admins/mods requesting that they approve the attachments. I believe they didn't know that you have to approve the attachments as a separate approval when you approve the post.

 

[speakers_86]

Check out this for some inspiration. I also have a thread called iTunes Controller which is basically an Access skin for iTunes. It's not meant for video, and there is one bug. Probably not what your looking for.

 

[CEH]

I'm lost.... Are you trying to attach something to your post and it won't let you???????

 

[boblarson]

I'm lost.... Are you trying to attach something to your post and it won't let you???????

No, I think it is YOUR attachments on YOUR thread Curtis that they can't get because they were never approved by a moderator or admin.

 

[CEH]

Ah..... I've been here so long I don't remember it doing that
Well, the app does work with video. You add "Media player" or whichever to your "Programs list" and then add the mpg or avi to "image" It is throwing an error when you add a "mpg" but if you ignore it, it will open the mpg in the media player. I'm not sure why it is throwing the error.... I thought I it set to accept all file extensions.... Someone who is a better coder then I will need to have a look.......I'm guessing because there is no image to display....could use an "If....then" in there with the error to display some default image.

 

[oreganr]

Hi CEH, thankyou very much for that image viewer..

I added a few photos, the only problem is, I cant see the database or code,
It only executes..

The only way I found to edit VB was to add a photo via application, then delete the photo, an exception error is thrown, then I can click debug..

How do I load it in Access so I can edit it ?