473,324 Members | 2,246 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

Playing mp3 files from access

347 100+
Hi
I have an access database that searches multiple entries with hyperlink fields theat link to mp3 files on a server, for some reason it will only play the first mp3 file listed and when you click on the link in other records it does nothing, has anyone got any ideas????

It used to work in access 2003 but since an upgrade to 2007 it does not seem to work
Mar 30 '09 #1
7 8615
puppydogbuddy
1,923 Expert 1GB
This link to a Microsoft pulic forum on the subject should answer all of your questions. Be sure and read all of the comments and download the free demo mdb.

http://groups.google.com/group/micro...f9ad1?lnk=raot
Mar 30 '09 #2
colinod
347 100+
Hi thanks for the link but that does not answer my question, i have the files playing in media player externally when you click on the link to the file in access but if i go to the next record it just does nothing when you click on the link
Mar 31 '09 #3
puppydogbuddy
1,923 Expert 1GB
Did you try the download from Doug Steele and the api link from Arvin Meyer?

Even though I have not used them, one or both of them were supposed to address the poster's request, which included the following (quote)

"Also this would be for every record that had an mp3 attachment. While on
that record, pressing the command button would play that particular file."

Is that not what you want? If you did try the above, please provide details as to what portion of the code provided did not work.
Mar 31 '09 #4
colinod
347 100+
Hi I have used the download from Doug Steel, copied the code for the play, stop and pause buttons and changed the code so that it looks at the entries that contain the path and file name to the mp3.

It comes back with compile error sub of function not defined and highlights PlayMP3 in the Private Sub cmdStart_Click() part of the code
Apr 1 '09 #5
puppydogbuddy
1,923 Expert 1GB
there is a activex control for WMP in Access2007. Did you register with windows via regsrvr32? Also, have you made the function public in a standard module?
Apr 1 '09 #6
colinod
347 100+
sorry i have no idea what you mean, how do i register and how do i make it public
Apr 1 '09 #7
puppydogbuddy
1,923 Expert 1GB
most activeX dll's have to be placed in the windows registry via regsrvr32 before they can be activated. Here is an easy way to register the dll (from the tip page of www.aadconsulting.com:

Open two Windows Explorer windows - one window displaying the .dll and the other Regsvr32.exe. Now drag Regsvr32.exe over the .dll, and presto the .dll is registered!

making a module public means declaring a standard code module as such, making it callable from any and all form modules. Did you check to see if Doug Steeles code had any standard modules?
Apr 2 '09 #8

Sign in to post your reply or Sign up for a free account.

Similar topics

4
by: Brian Basquille | last post by:
Hello all, What is the syntax for simply playing a WAV file in your program? Am learning VB and have two VB books but don't wanna root through them to find the code. Any help would be much...
5
by: Lauren Wilson | last post by:
Hi Folks, I have an Access 2k app that is often run on a LAN with several users. Unfortunately there is one feature that fails to work in that setup. Our app allows the user to play WAV audio...
5
by: Johnny M | last post by:
I use the following code to play WAV files from Access. Is there a method to play MP3 files from an Access event or control.: '***************************************************** Option Compare...
7
by: Lee Moody | last post by:
I just want quick and easy way to play a .wav file out the standard sound device. It could even be as simple as activating a sound assigned to an existing windows sound event. Any suggestions?...
0
by: Raven Jones | last post by:
Heya all, I'm working on a web-based application (using ASP.NET and C# on .NET 1.1.4322, supporting only IE6 for Windows) that allows for file uploads. Screen real estate is at a premium, so I...
8
by: kp87 | last post by:
I am a little bit stuck .... I want to play a bunch of soundfiles randomly, but i want to give each soundfile a rating (say 0-100) and have the likelihood that the file be chosen be tied to its...
2
by: Mr. Murad Jamal | last post by:
Dear guys, I have 7 .wav files in C:\ directory , I'd play them all by clicking on "cmdStart" button on a Visual Basic 2005- Windows Application Form. I thought I should use this segment of...
1
by: majestik | last post by:
Question, can I see an event in Javascript that tells me a video starts playing using the <embed src="file.wmv>. I stream the video, but there is a wait time and wanted to pop up a message telling...
2
by: =?Utf-8?B?Qm9iQWNoZ2lsbA==?= | last post by:
How can I best play several mp3 files one immediately after the other? Will this tie up the AxWindowsMediaPlayer1 instance such that I can't use the instance again until the files finish playing...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.