Video & Audio via Access Form

[gstylianou]

Hi

Sorry - this post got overlooked
First of all I've not looked at any of the code in this database.

I can move from track to track but at the moment it doesn't do so automatically

So, that means that only arnelgp can help..?

Dear arnelgp if you have a little bit more time please have a look

Thanks in advanced

 

[arnelgp]

hellow...
again if you would try.
made a couple of changes.
my test shows it is now
play the next song/video.

 

[gstylianou]

hellow...
again if you would try.
made a couple of changes.
my test shows it is now
play the next song/video.

Finally…!!!! That's it…!!! After many post we found finally the edge ...
Many many - thank you again my friend .. !!!

 

[isladogs]

So, that means that only arnelgp can help..?

Dear arnelgp if you have a little bit more time please have a look

Thanks in advanced

What I meant was I hadn't looked at the code at that time...
However I've done a few things since then & merged these into the version that arnel posted this morning.
See whether you like my changes or not ...

Changes include ...
1. Modified the app so it's in a 'floating window' on the desktop
2. The form frmWMP now opens at startup
3. Added priority number & media type to the list
4. Changed Priority field from a text datatype to a number datatype so it sorts correctly i.e. 1,2,3,4 ...`11,12 ... instead of 1,10,11,12,2,21,3 etc
5. Changed the labels to English ... you may wish to swop them back to Greek!

There are several issues & additional features I might return to at some point in the future.
For example:
a) Restoring the database window means the form has to be reloaded
b) Add code to allow form frmMovies to be sorted by any of the column headers
c) File names containing apostrophes create an error (easy to fix)
d) Filter file list by file type
e) Add artist name / album name / remove track number from file list (etc)
f) Allow file list priority to be changed from main form

 

[gstylianou]

What I meant was I hadn't looked at the code at that time...
However I've done a few things since then & merged these into the version that arnel posted this morning.
See whether you like my changes or not ...

Changes include ...
1. Modified the app so it's in a 'floating window' on the desktop
2. The form frmWMP now opens at startup
3. Added priority number & media type to the list
4. Changed Priority field from a text datatype to a number datatype so it sorts correctly i.e. 1,2,3,4 ...`11,12 ... instead of 1,10,11,12,2,21,3 etc
5. Changed the labels to English ... you may wish to swop them back to Greek!

There are several issues & additional features I'm might return to at some point in the future.
For example:
a) Restoring the database window means the form has to be reloaded
b) Add code to allow form frmMovies to be sorted by any ofhe column headers
c) File names containing apostrophes create an error (easy to fix)
d) Filter file list by file type
e) Add artist name / album name / remove track number from file list (etc)
f) Allow file list priority to be changed from main form

............................................................................................................................
What to tell you guys ... ..I sincerely thank you very much because without your help I could not do this because my knowledge at Vba is at least basis mode ..!

My friend Ridders i appreciate your intention in order to create a complete solution .... I will look and study your example ...

Thank you again..