Results 1 to 14 of 14
  1. #1
    nigelm is offline Novice
    Windows 10 Office 365
    Join Date
    Sep 2022
    Posts
    5

    FollowHyperlink video options


    I use a button with VBA code to launch videos stored on my laptop e.g. "Application.FollowHyperlink C:\video.mp4". This launches the video with my selected default media player (outside of Access), which is excellent. However, I've got data in my database that tells me that something happens at a specific point in the video e.g. from 2 mins 20 secs until 3 min 4 secs. I've searched for parameters on urls for starting and stopping videos at specified points, so my question is - are there any parameters for the FollowHyperlink command that I can use to implement this using VBA? Many thanks.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    FollowHyperlink has a SubAddress argument but I doubt that can process video or audio time positions, however, I could be wrong.

    The Access hyperlink structure can also specify sublocations, like a worksheet and cell of an Excel file http://allenbrowne.com/casu-09.html, but again doubt can handle time positions.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    Methinks much of that will depend on what the "default" player is, which has not been revealed. YouTube urls support time start parameters, but I have no idea if it supports time end parameters. This could be about Windows Media Player, Quick Time, VLC or who knows what. The support documentation for the app would be the place to start?
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  4. #4
    nigelm is offline Novice
    Windows 10 Office 365
    Join Date
    Sep 2022
    Posts
    5
    Thanks. My current default player is Windows 10 Film & TV, the videos are mp4 and mpg format, but I guess I was naively hoping for a generic solution. I would be happy with any video player solution that supports my required functionality, so would be happy to change my default player if I could find a way to just play a required snippet from a whole video. Just to explain a bit more, I have some local history videos of 10 minutes duration that feature different people. I have the people recorded in my database and want to be able to say, for example, John Smith appears from 2:04 to 3:42 then click a button to just watch/show that part of the video.

  5. #5
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,858
    You would need to do some some work if you use VLC it seems?

    https://www.vlchelp.com/skipping-and...rtions-in-vlc/

    Found via https://www.google.com/search?q=vlc+...hrome&ie=UTF-8
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  6. #6
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    First link of 66 Google results - also contains a few more links. Seems that the start time thing is doable.
    https://stackoverflow.com/questions/...-time-position
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  7. #7
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    That's one of many links I already explored. I tried that code with WMP ActiveX control on form (not quite what the OP is asking for). Get "doesn't support this property or method" error. Note that answer was never accepted as a solution.

    Referenced links on that thread concern: Microsoft Windows Media Player Software Development Kit (SDK)

    As suggested by one of the references, also tried: Me.wpm1.Controls.CurrentPosition, get "Method or data member not found".
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  8. #8
    nigelm is offline Novice
    Windows 10 Office 365
    Join Date
    Sep 2022
    Posts
    5
    Thanks for the replies. I've had a bit of a hunt around but not found anything workable yet, but I will keep looking. Back in 'the good old days' programs had multiple command line options e.g. /start= /end= but I've yet to find anything equivalent in the current crop of 'apps'.

  9. #9
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,858
    Quote Originally Posted by nigelm View Post
    Thanks for the replies. I've had a bit of a hunt around but not found anything workable yet, but I will keep looking. Back in 'the good old days' programs had multiple command line options e.g. /start= /end= but I've yet to find anything equivalent in the current crop of 'apps'.
    Well my thoughts were you would create a m3u file on the fly, and just open that. Just as shown in the link I posted.
    Easy enough to do, with a quick Google?
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  10. #10
    nigelm is offline Novice
    Windows 10 Office 365
    Join Date
    Sep 2022
    Posts
    5
    Yes, thanks, easy enough to do but I was hoping not to have to edit/transform/package or otherwise harm any video files, but am looking for a 'code only' solution.

  11. #11
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,858
    Quote Originally Posted by nigelm View Post
    Yes, thanks, easy enough to do but I was hoping not to have to edit/transform/package or otherwise harm any video files, but am looking for a 'code only' solution.
    You do not 'harm' any video files? In fact you do not even touch the video file. You just give pointers as to where to start and stop? and the name of course.?

    Mind you, I cannot get it to recognise the start and stop yet
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  12. #12
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,858
    Well I have tried all morning and I cannot get it to work Creating the m3u file was the easy part. Converting to seconds a little harder, but still got that done.
    All the links I have tried that purportedly show how it is done, just generate an error or do nothing.

    I did notice that VLC would prefix the path with the location of where the m3u file is located, which is as much use as a chocolate fireguard, unless you copy the file there, and even when I did that, it still did not work.
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  13. #13
    nigelm is offline Novice
    Windows 10 Office 365
    Join Date
    Sep 2022
    Posts
    5

    Thumbs up

    Thanks for trying. It would seem to me like useful functionality, so I'm surprised that it is proving difficult to solve.

  14. #14
    davegri's Avatar
    davegri is offline Excess Access
    Windows 11 Access 2019
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,388
    VideoPlayer-davegri-v02.zip Updated from v01

    This player will allow entry of start-stop times, showing that it is possible. However, it won't allow entry of those times from an external source.

    Click image for larger version. 

Name:	video.png 
Views:	7 
Size:	55.2 KB 
ID:	48833

    custom right click menus.

    Click image for larger version. 

Name:	rc1.png 
Views:	6 
Size:	16.2 KB 
ID:	48836

    another
    Click image for larger version. 

Name:	rc2.png 
Views:	6 
Size:	11.5 KB 
ID:	48837
    Last edited by davegri; 09-29-2022 at 11:45 PM. Reason: updated version, added images

Please reply to this thread with any new information or opinions.

Similar Threads

  1. followhyperlink
    By Agrilima in forum Access
    Replies: 2
    Last Post: 02-12-2021, 08:25 AM
  2. Error Handling for FollowHyperlink
    By will71110 in forum Programming
    Replies: 7
    Last Post: 08-28-2016, 03:00 PM
  3. using FollowHyperlink
    By Jen0dorf in forum Modules
    Replies: 5
    Last Post: 11-24-2015, 04:30 PM
  4. Replies: 3
    Last Post: 06-23-2013, 05:29 PM
  5. FollowHyperlink Help
    By RachelBedi in forum Access
    Replies: 6
    Last Post: 01-18-2013, 08:22 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums