playing mp3 files with WMP ActiveX in a form

[Repent]

I see that there is a activex control for WMP in Access2007. If I add it to
a form, how can I setup a command buttom on the form so that an mp3 song
file, residing inside the DB via an attachment field in a table, could be
played inside that ActiveX WMP control?

chris

 

[Repent]

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

chris

 

[Arvin Meyer [MVP]]

I see that there is a activex control for WMP in Access2007. If I add it
to a form, how can I setup a command buttom on the form so that an mp3 song
file, residing inside the DB via an attachment field in a table, could be
played inside that ActiveX WMP control?

If you have wmp registered on you machine, here is an api that *may* work:

http://www.mvps.org/access/api/api0011.htm

If it does, it will free you from any of the negative problems of using
third party controls.

 

[Repent]

not sure what to do with that?

If you have wmp registered on you machine, here is an api that *may* work:

http://www.mvps.org/access/api/api0011.htm

If it does, it will free you from any of the negative problems of using
third party controls.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Douglas J. Steele]

I showed how to play mp3 files in my November, 2004 "Access Answers" column
in Pinnacle Publication's "Smart Access". You can download the column (and
sample database) for free at
http://www.accessmvp.com/DJSteele/SmartAccess.html

 

[sebastico]

Hi

I have been trying your suggestion, nevertheless, I don't know how to
declare the Function code in the cmd button. If possible, step by step is
highly appreciated.

 

[Douglas J. Steele]

I'm not sure I can explain it any better than I already have in the article.
The sample database includes all the code you need.

 

[sebastico]

Hi

I followed the instruction. However, when I click the "?" button Microsoft
Visual Basis display:
Compile error:
Ambiguos name detected: ahtAddFilterItem

Could help me to fix this error. Just in case I'm working with MS Access 2003.

Thank you very much indeed

 

[Douglas J. Steele]

That error means you have the function ahtAddFilterItem twice in your
application.

While in the VB Editor, use Ctrl-F to find Function ahtAddFilterItem in the
entire database. Assuming they're the same, delete one of them.

 

[rogerdaleowens]

I see that there is a activex control for WMP in Access2007. If I add itto
a form, how can I setup a command buttom on the form so that an mp3 song
file, residing inside the DB via an attachment field in a table, could be
played inside that ActiveX WMP control?

chris

There is an ActiveX control 'Audio Player ActiveX' This control does work.The only thing is I can't find a place to purchase it. It is shareware and it gives you some time to use it then it will stop working. If either you find the key to this software or a place to purchase it then re-post here.