Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 01-11-2018, 03:24 AM   #16
ridders
Newbee moderator
Gold Supporter
 
ridders's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 5,515
Thanks: 79
Thanked 1,366 Times in 1,275 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

I tried it in both Access 2010 & Access 2016 with Windows 10 Pro

__________________
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.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


-------------------------
nil illegitimi carborundum est
ridders is offline   Reply With Quote
Old 01-11-2018, 03:53 AM   #17
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
I tried it in both Access 2010 & Access 2016 with Windows 10 Pro
told you..its strange because also i'm using 2016 32bit office...... Sorry....i cannot help....
gstylianou is offline   Reply With Quote
Old 01-11-2018, 05:04 AM   #18
ridders
Newbee moderator
Gold Supporter
 
ridders's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 5,515
Thanks: 79
Thanked 1,366 Times in 1,275 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

I believe Windows Media Player was removed from Windows 10.
I don't have it on my PC and its not an optional feature I can add

UPDATE:
That's odd. My laptop runs Windows 10 Home & does have Media Player
I can load the app without error on the laptop.
Had a bit of trouble loading an MP3 file (possibly as I can't read Greek) but its now playing perfectly

Now I'm intrigued and will investigate further ....

__________________
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.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


-------------------------
nil illegitimi carborundum est

Last edited by ridders; 01-11-2018 at 05:21 AM.
ridders is offline   Reply With Quote
The Following User Says Thank You to ridders For This Useful Post:
gstylianou (01-11-2018)
Old 01-11-2018, 11:23 AM   #19
ridders
Newbee moderator
Gold Supporter
 
ridders's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 5,515
Thanks: 79
Thanked 1,366 Times in 1,275 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

After some research about why Media Player was missing on my desktop PC, I found the following info at
https://betanews.com/2017/10/09/wind...-media-player/

In case its useful to anyone else, here are the relevant parts of that article

Quote:
The feature's removal came to light when users installed KB4046355 on devices running Windows 10 version 1709 -- the Fall Creators Update.

This update, referred to as FeatureOnDemandMediaPlayer, removes Windows Media Player from the OS, although it doesn’t kill access to it entirely.

If you want the media player back you can install it via the Add a Feature setting. Open Settings, go to Apps > Apps & Features, and click on Manage optional features.

Select Add a feature and then scroll down to the Windows Media Player entry and click on Install.
Whilst its old technology, it does still have its uses & I now have it back again.

Oddly the same update didn't remove WMP from my Windows laptop or tablet
__________________
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.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


-------------------------
nil illegitimi carborundum est
ridders is offline   Reply With Quote
Old 01-12-2018, 05:56 AM   #20
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

Dear friends,

I'm here again because of another one serious issue. After the modification of the vba code (by arneg) in order the player to change automatically the next track, now i cannot add new song and i god the attached message... Please note that, the selected URL can store normally into a table but cannot be visible into MoveList..

Please your help again...!!
gstylianou is offline   Reply With Quote
Old 01-12-2018, 05:59 AM   #21
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

Dear friends,

I'm here again because i found new problem after the modification of the code in order the player to change automatically the next track. The new problem is that i cannot add new track into a list..!!! If you try to do that we will have the attached error message..!!

Please your help...!!!
Attached Images
File Type: jpg Capture.JPG (55.7 KB, 76 views)
gstylianou is offline   Reply With Quote
Old 01-12-2018, 06:09 AM   #22
ridders
Newbee moderator
Gold Supporter
 
ridders's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 5,515
Thanks: 79
Thanked 1,366 Times in 1,275 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

That's what I was referring to in post 18
I could get it to play but not to list any of my files

__________________
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.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


-------------------------
nil illegitimi carborundum est
ridders is offline   Reply With Quote
Old 01-13-2018, 12:45 AM   #23
arnelgp
Registered User
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 6,187
Thanks: 54
Thanked 1,985 Times in 1,898 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

here again your Jukebox.
review the code i added
on Form:

frmWMP : MovList_DblClick event
frmMovie: cmdAdd_Click event
Attached Files
File Type: zip Juke Box Database.zip (51.0 KB, 24 views)
__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
Old 01-13-2018, 09:32 AM   #24
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
here again your Jukebox.
review the code i added
on Form:

frmWMP : MovList_DblClick event
frmMovie: cmdAdd_Click event
Dear friend,

Maybe i make something wrong?
Attached Images
File Type: jpg Capture.JPG (61.1 KB, 76 views)
gstylianou is offline   Reply With Quote
Old 01-13-2018, 11:55 AM   #25
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

Dear arnelgp,

I'm trying to add new track when the frmWMP is open but i'm getting the attached error (attached on my post 24..! This is the first problem... In order to solve the problem i tried to write the following line of code (and i'm not sure if i'm correct)

Private Sub cmdAdd_Click()
Dim fdlg As Object
Dim sFile As String
Dim BM As String 'This line of code its my opinion..
Set fdlg = Application.FileDialog(3)

With fdlg
.AllowMultiSelect = False
.Title = "test"
.Filters.Clear
.Filters.Add "Αρχεία", "*.mp4,*.mp3,*.doc, *.docx, *.xls, *.xlsx, *.pdf"


If .Show Then
sFile = fdlg.SelectedItems(1)
'''''''''''''''''
' agp
' 12-jan-2018
'
With Me.Recordset
.AddNew
!MovieUrl.Value = sFile
.Update
BM = .LastModified
End With
Me.Bookmark = BM
Forms!frmWMP.MovList.Requery

Dim wmp As WindowsMediaPlayer
Set wmp = Forms!frmWMP!wmp1.Object
wmp.currentPlaylist.appendItem wmp.newMedia(sFile)
'
' eoc
'''''''''''''
End If

End With
End Sub

.................................................. .................................................. .........
After the above i'm not getting any error and i can select new track normally from frmMovies. But, by selecting the new track i cannot see the Url to append into frmMovies....

Please your help..
gstylianou is offline   Reply With Quote
Old 01-15-2018, 09:51 AM   #26
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
here again your Jukebox.
review the code i added
on Form:

frmWMP : MovList_DblClick event
frmMovie: cmdAdd_Click event
My friend arnelgp,

I will appreciate if you can find some time in order to look again to the problem which we have so that I can finish the project.

Informationally, open the database and try to add new record. You will see the code problem..

Thank you
gstylianou is offline   Reply With Quote
Old 01-15-2018, 10:05 AM   #27
arnelgp
Registered User
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 6,187
Thanks: 54
Thanked 1,985 Times in 1,898 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

here again, i think we got it this
time.
Attached Files
File Type: zip Juke Box Database.zip (56.5 KB, 8 views)
__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
Old 01-15-2018, 10:36 AM   #28
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
here again, i think we got it this
time.
My friend,

First of all thank you for your fast response.But, when i'm trying to open the frmWMP again i'm getting the attached error message...

Sorry again....please...could you please check whats going wrong?
Attached Images
File Type: jpg 1.JPG (47.8 KB, 8 views)
gstylianou is offline   Reply With Quote
Old 01-15-2018, 10:48 AM   #29
arnelgp
Registered User
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 6,187
Thanks: 54
Thanked 1,985 Times in 1,898 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

Debug it and note which code is faulty.
Did you download my latest revision.
__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
Old 01-15-2018, 11:00 AM   #30
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
Debug it and note which code is faulty.
Did you download my latest revision.
I download from post #27, it is not the correct version? Moreover, with debugging i'm not getting any error message, the error is appear only when you open the frmWMP... The error said that : "there is not object in this Control"

??? i don't know..

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 10:56 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