Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 01-15-2018, 11:05 AM   #31
arnelgp
Newly Registered User
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 5,992
Thanks: 54
Thanked 1,923 Times in 1,837 Posts
arnelgp is a jewel in the rough arnelgp is a jewel in the rough arnelgp is a jewel in the rough arnelgp is a jewel in the rough
Re: Video & Audio via Access Form

Im not getting any error. When the error appears press the debug button and see which line.

__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
Old 01-15-2018, 11:10 AM   #32
arnelgp
Newly Registered User
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 5,992
Thanks: 54
Thanked 1,923 Times in 1,837 Posts
arnelgp is a jewel in the rough arnelgp is a jewel in the rough arnelgp is a jewel in the rough arnelgp is a jewel in the rough
Re: Video & Audio via Access Form

Download it again.
Attached Files
File Type: zip AccessMediaPlayer.zip (43.4 KB, 11 views)
__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
Old 01-15-2018, 11:27 AM   #33
ridders
AWF VIP
Gold Supporter
 
ridders's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 4,921
Thanks: 75
Thanked 1,217 Times in 1,134 Posts
ridders is a jewel in the rough ridders is a jewel in the rough ridders is a jewel in the rough ridders is a jewel in the rough
Re: Video & Audio via Access Form

Sorry arnel

I also downloaded it in post 27 and again in post 32
Both have the same issue
When frmWMP is opened the error 'there is no object in this control' appears followed by almost the same error message with error number 2683

Also the database doesn't close down properly & can't then be reopened without going into task manager

I haven't looked at any of the code - back to you ...

__________________
Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left and leave a comment.

New example databases:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
ridders is offline   Reply With Quote
Old 01-15-2018, 11:30 AM   #34
arnelgp
Newly Registered User
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 5,992
Thanks: 54
Thanked 1,923 Times in 1,837 Posts
arnelgp is a jewel in the rough arnelgp is a jewel in the rough arnelgp is a jewel in the rough arnelgp is a jewel in the rough
Re: Video & Audio via Access Form

I have no error on my pc. Delete the player control and add it again. Named it as it were.
__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
Old 01-15-2018, 11:36 AM   #35
ridders
AWF VIP
Gold Supporter
 
ridders's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 4,921
Thanks: 75
Thanked 1,217 Times in 1,134 Posts
ridders is a jewel in the rough ridders is a jewel in the rough ridders is a jewel in the rough ridders is a jewel in the rough
Re: Video & Audio via Access Form

Yup - the media player control on the form was corrupted.

Replacing it worked for me - more important, hopefully it will for the OP
I'd forgotten how irritating the waveform patterns are ...
__________________
Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left and leave a comment.

New example databases:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
ridders is offline   Reply With Quote
Old 01-15-2018, 11:41 AM   #36
gstylianou
Newly Registered User
 
Join Date: Dec 2013
Posts: 80
Thanks: 24
Thanked 1 Time in 1 Post
gstylianou is on a distinguished road
Re: Video & Audio via Access Form

Quote:
Originally Posted by ridders View Post
Yup - the media player control on the form was corrupted.

Replacing it worked for me - more important, hopefully it will for the OP
I'd forgotten how irritating the waveform patterns are ...
Dear Ridders,

Can you please upload your example with new media player because i tried to add new media player from ActiveX commands but....nothing...
gstylianou is offline   Reply With Quote
Old 01-15-2018, 11:56 AM   #37
gstylianou
Newly Registered User
 
Join Date: Dec 2013
Posts: 80
Thanks: 24
Thanked 1 Time in 1 Post
gstylianou is on a distinguished road
Re: Video & Audio via Access Form

Quote:
Originally Posted by ridders View Post
Yup - the media player control on the form was corrupted.

Replacing it worked for me - more important, hopefully it will for the OP
I'd forgotten how irritating the waveform patterns are ...
Dear Ridders and arnelgp,

With the replacement of media player now the player is working...but we are again to the back...!! The player cannot recognize the next song so cannot change track.... Try it please a let me know...

gstylianou is offline   Reply With Quote
Old 01-15-2018, 11:58 AM   #38
ridders
AWF VIP
Gold Supporter
 
ridders's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 4,921
Thanks: 75
Thanked 1,217 Times in 1,134 Posts
ridders is a jewel in the rough ridders is a jewel in the rough ridders is a jewel in the rough ridders is a jewel in the rough
Re: Video & Audio via Access Form

Quote:
Originally Posted by gstylianou View Post
Dear Ridders,

Can you please upload your example with new media player because i tried to add new media player from ActiveX commands but....nothing...
Attached
I've restored the modification suggested by moke in an earlier post & added Option Explicit where it was missing from one module

However I had already deleted your list of songs so you will need to re-import them from a backup.

Three other suggestions:
1. This would be an ideal database to have 'floating' on the desktop without the Access application window. If you don't know how to do that, see this link
https://www.access-programmers.co.uk...d.php?t=293584

2. It would make the player much more user friendly if you could add a group of files at once ... or even better, use drag & drop

3. Not sure if its possible, but have you considered using the newer Groove VBA library instead of Media Player?
Also not sure if there's a control for this but there are certainly a lot of Groove libraries!

EDIT - just saw your last post - I can change track. Works for videos also
Attached Files
File Type: zip AccessMediaPlayer.zip (53.2 KB, 13 views)
__________________
Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left and leave a comment.

New example databases:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Last edited by ridders; 01-15-2018 at 12:05 PM.
ridders is offline   Reply With Quote
Old 01-16-2018, 12:39 AM   #39
gstylianou
Newly Registered User
 
Join Date: Dec 2013
Posts: 80
Thanks: 24
Thanked 1 Time in 1 Post
gstylianou is on a distinguished road
Re: Video & Audio via Access Form

Quote:
Originally Posted by ridders View Post
Attached
I've restored the modification suggested by moke in an earlier post & added Option Explicit where it was missing from one module

However I had already deleted your list of songs so you will need to re-import them from a backup.

Three other suggestions:
1. This would be an ideal database to have 'floating' on the desktop without the Access application window. If you don't know how to do that, see this link
https://www.access-programmers.co.uk...d.php?t=293584

2. It would make the player much more user friendly if you could add a group of files at once ... or even better, use drag & drop

3. Not sure if its possible, but have you considered using the newer Groove VBA library instead of Media Player?
Also not sure if there's a control for this but there are certainly a lot of Groove libraries!

EDIT - just saw your last post - I can change track. Works for videos also

Dear friend Ridders,

First of all,i would like to thank you very much about your usefull informations..I will read all the details and i will see what is better to do.

But, already i downoloaded your example and thank you very much, is working but cnnot change the track again... Have you see it?

Thanks again
gstylianou is offline   Reply With Quote
Old 01-16-2018, 10:34 AM   #40
ridders
AWF VIP
Gold Supporter
 
ridders's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 4,921
Thanks: 75
Thanked 1,217 Times in 1,134 Posts
ridders is a jewel in the rough ridders is a jewel in the rough ridders is a jewel in the rough ridders is a jewel in the rough
Re: Video & Audio via Access Form

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
__________________
Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left and leave a comment.

New example databases:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
ridders is offline   Reply With Quote
Old 01-16-2018, 11:46 PM   #41
gstylianou
Newly Registered User
 
Join Date: Dec 2013
Posts: 80
Thanks: 24
Thanked 1 Time in 1 Post
gstylianou is on a distinguished road
Re: Video & Audio via Access Form

Quote:
Originally Posted by ridders View Post
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
gstylianou is offline   Reply With Quote
Old 01-17-2018, 12:37 AM   #42
arnelgp
Newly Registered User
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 5,992
Thanks: 54
Thanked 1,923 Times in 1,837 Posts
arnelgp is a jewel in the rough arnelgp is a jewel in the rough arnelgp is a jewel in the rough arnelgp is a jewel in the rough
Re: Video & Audio via Access Form

hellow...
again if you would try.
made a couple of changes.
my test shows it is now
play the next song/video.
Attached Files
File Type: zip Juke Box Database.zip (60.3 KB, 11 views)
__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
The Following User Says Thank You to arnelgp For This Useful Post:
gstylianou (01-17-2018)
Old 01-17-2018, 03:06 AM   #43
gstylianou
Newly Registered User
 
Join Date: Dec 2013
Posts: 80
Thanks: 24
Thanked 1 Time in 1 Post
gstylianou is on a distinguished road
Re: Video & Audio via Access Form

Quote:
Originally Posted by arnelgp View Post
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 .. !!!
gstylianou is offline   Reply With Quote
Old 01-17-2018, 10:25 AM   #44
ridders
AWF VIP
Gold Supporter
 
ridders's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 4,921
Thanks: 75
Thanked 1,217 Times in 1,134 Posts
ridders is a jewel in the rough ridders is a jewel in the rough ridders is a jewel in the rough ridders is a jewel in the rough
Re: Video & Audio via Access Form

Quote:
Originally Posted by gstylianou View Post
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
Attached Files
File Type: zip AccessMediaPlayer.zip (83.8 KB, 13 views)
__________________
Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left and leave a comment.

New example databases:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Last edited by ridders; 01-17-2018 at 12:20 PM. Reason: Typos
ridders is offline   Reply With Quote
Old 01-17-2018, 11:18 AM   #45
gstylianou
Newly Registered User
 
Join Date: Dec 2013
Posts: 80
Thanks: 24
Thanked 1 Time in 1 Post
gstylianou is on a distinguished road
Re: Video & Audio via Access Form

Quote:
Originally Posted by ridders View Post
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..

gstylianou is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
VLC audio and video file & crashes DevAccess Modules & VBA 8 07-03-2017 11:30 PM
Record an audio file when a command button is clicked on a form SteveL Forms 4 08-24-2015 08:24 AM
Field for mp4 (video) files in Access RonW7341 Tables 0 09-27-2014 08:08 PM
video on a form (ms access 2007) budzprog Forms 2 05-19-2012 09:49 AM




All times are GMT -8. The time now is 09:31 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World