Converting speech directly to text field using PC Mic .

[SHAMI]

Hi All

Is there a function that helps me to converts speech and inserting to text field using PC Mic , using Access 2010 ?



My Regards

[Welshgasman]

Try asking https://chatgpt.com/ with 'convert speech to text in VBA' and copy the code.

[isladogs]

The functionality is built into recent versions of Windows but not officially supported in Access. However it can work well for freeform text (long text fields)
See my article: Dictation in Access together with YoiuTube video: Using Dictation in Access

[Welshgasman]

The functionality is built into recent versions of Windows but not officially supported in Access. However it can work well for freeform text (long text fields)
See my article: Dictation in Access together with YoiuTube video: Using Dictation in Access

I wish you had replied sooner.
I just spent an hour with ChatGPT getting it working. :-)

[isladogs]

No idea what code ChatGPT suggested - my method uses standard Windows functionality

[jojowhite]

there is a also a sample Excel file for download here:
Integrating speech recognition with VBA
Using your voice to fill in a VBA form

[isladogs]

@jojowhite/@arnelgp
Both of your links in post #6 give a 500 - internal server error - at least for me

[jojowhite]

it was working a while ago, anyway here are the Excel files from
Wise Owl site

[Welshgasman]

@jojowhite/@arnelgp
Both of your links in post #6 give a 500 - internal server error - at least for me

They did work, as I had a quick peek, but the code did not work for me.

[jojowhite]

They did work, as I had a quick peek, but the code did not work for me.

you first need to "train" your microphone.

[Welshgasman]

you first need to "train" your microphone.

Well I got it working with ChatGPT just as an excercise, so no problem there.