Placing mp3 file in text box

[Jaap]

Dear Forum, I would like to know how I can play a self-made, short mp3 sound file in a text box when the text box is clicked.


I have heard that you first have to put something in Module, and then in VBA.
Can you help me, please?

[Bob Fitz]

A google search retuned this: how to play mp3 direct from database | Access World Forums (access-programmers.co.uk)
plus a host of YouTube videos.

[moke123]

Not sure what your end game is with the mp3 but if you just want to tell the user something , a simpler option may be using the speech api.

Mike Wolfe has example code here... https://nolongerset.com/speak/

[Jaap]

Thank you all,

To use Speech you need to open 'Microsoft Speech Object Library', which is located in C:\Windows\System32\Speech\Common\It contains 'sapi.dll' file, but I don't know how to open this Reference - Translator with 'sapi.dll'
I hope you can help me?

[moke123]

You don't open it, you just set a reference to it by checking the box and clicking ok.
That allows you to use "Early Binding" as colin does in his app your showing.

Mike's version is using "late binding" where you do not need to set the reference but you lose being able to use intellisense with the object.

https://learn.microsoft.com/en-us/do...-late-binding/

[Jaap]

Thank you, I would like to open 'api.dll', but with which app?
Notepad does not work?

[NoellaG]

you can open dll files with visual studio, you can load the community version for free

[Jaap]

Dear NoellaG, Visual Studio is installed, thank you,

Could you please give me some pointers on how to open C:\Windows\System32\Speech\Common\sapi.dll?

[NoellaG]

Looking at the screen, you're still installing the program. Once installed you can use file -> open-> file or project

[Jaap]

Well, I hope this is ok?
I can't open sapi.dll with this menu...

[Jaap]

New Install, is this a good menu, please?

[Welshgasman]

Just what do you expect to do when you open this dll?

[NoellaG]

https://learn.microsoft.com/en-us/vi...e&view=vs-2022

[Edgar]

Add a Windows Media Player control from the ActiveX list, add to the click event of your textbox this:
Me.WindowsMediaPlayer0.Object.Url = "C:/Path/To/Sound.mp3"

> WindowsMediaPlayer0 is the name of the control, modify as required
> "C:/Path/To/Sound.mp3" is the path to your mp3 file, modify as required

[Jaap]

Just what do you expect to do when you open this dll?

This is what I did, like you told me: File, Open, then found api.dll Open, but only Edit was possible, not Open api.dll