MS Access Dictation

spaLOGICng

Member
Local time
Today, 13:36
Joined
Jul 27, 2012
Messages
163
Hi,

To the best of my understanding, MS has NOT added any Dictation ability to Access as it has for Word and Outlook.

Has anybody ever implemented a 3rd party Dictation Add-in for MS Access? If so, can you reply with link(s) to source?

Much thanks!
 
I'm sorry, I'm not going to be very helpful since my memory is failing me on exactly how I did it. About 10 years ago a client asked me to implement this feature. I turned on the speech recognition and then spoke into the Access form. It actually worked. It recognized the words tab and enter and click. We never pursued it because I thought the process was clunky. The documentation was unhelpful and I couldn't figure out how to scroll combos. We didn't go any further with it, mostly because I convinced the client that a bunch of people in the same room entering commands was going to be a problem unless they were wearing headsets and that would conflict with the headsets they were using as they took phone orders. I went back and tried the app a few years later and could not get the speech recognition to work again. I didn't pursue it. All I can tell you is that at one point in time, you could type into Access.

I tried the same thing with excel around March of 2022. I had a bunch of handwritten data that I wanted to enter and it was a real pain to transpose it so I tried the speech recognition again (on my old computer running O2010 and Win 7. This computer hasn't been updated in years because I never connect it to the internet. It worked like a champ. After three hours, I was tired so I closed the spreadsheet and went to bed. I could never get it to work again. The word Tab simply would not move from one cell in the spreadsheet to the next. It kept popping up to the ribbon and clicking something there. I tried help and forums, etc and got nowhere. Every response was that it only works with Word. So I tried to use a table in word (If you can't beat em' join em') but couldn't get tab to work correctly there either. I tried on a newer PC running O365 and had no success at all with either Excel or Word.
 
Although not officially supported in Access or Excel, dictation is perfectly possible in long text (memo) field controls.
I've used it a number of times, primarily to read in fairly long sections of text from a printed source.

I gave a short demonstration of this as a small part of my YouTube video:

The relevant section starts at 02:21

Dictation isn't practical in other controls such as short text fields

EDIT:
I wouldn't bother with a third party utility until you have at least tried the built-in Windows dictation tool

The only time I tried a third-party tool was using Dragon Dictate in the days of Office 97.
I purchased it just before having a sinus operation and spent some time getting my computer to reliably recognise my voice whilst signed off work & recuperating.

Stupid idea! Once I had recovered fully , my voice sounded completely different to the computer . . . so it no longer worked well and I totally lost interest in using dictation for about 20 years.
 
Last edited:

Users who are viewing this thread

Back
Top Bottom