Video & Audio via Access Form (2 Viewers)

gstylianou

Registered User.
Local time
Today, 19:55
Joined
Dec 16, 2013
Messages
357
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

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 00:55
Joined
May 7, 2009
Messages
19,230
hellow...
again if you would try.
made a couple of changes.
my test shows it is now
play the next song/video.
 

Attachments

  • Juke Box Database.zip
    60.3 KB · Views: 240

gstylianou

Registered User.
Local time
Today, 19:55
Joined
Dec 16, 2013
Messages
357
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

MVP / VIP
Local time
Today, 17:55
Joined
Jan 14, 2017
Messages
18,211
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
 

Attachments

  • AccessMediaPlayer.zip
    83.8 KB · Views: 225
Last edited:

gstylianou

Registered User.
Local time
Today, 19:55
Joined
Dec 16, 2013
Messages
357
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..
 

Users who are viewing this thread

Top Bottom