Go Back   Access World Forums > Microsoft Access Reference > Sample Databases

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 10-01-2017, 01:09 PM   #1
ridders
AWF VIP
Gold Supporter
 
ridders's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 2,923
Thanks: 54
Thanked 686 Times in 634 Posts
ridders has a spectacular aura about ridders has a spectacular aura about
Text to Speech Example Database

This is a quick demo to show text to speech can be added to an Access database.
It follows on from the speaking clock that I uploaded some time ago



Click on a button and the sample text will be converted to speech
You can also enter your own text and get that played back ...

I find it works well for almost all cases though some words can be pronounced in 2 ways depending on context e.g. live, sow
Long words like 'antidisestablishmentarianism' or 'supercalifragilisticexpialidocous' - no problem
It even makes a pretty good attempt at 'otorhinolaryngologist' which I struggle to say

Of course the real fun is trying to get it to mispronounce words ... or to swear at you!

There are some serious uses for doing this e.g. assistance for those with poor sight.
If you click the checkbox at the bottom of the form, the control tip text for e.g. a button will be spoken when the mouse is moved over the button.
Unless you do have poor sight, you will probably want to switch that feature off again fairly quickly ....!

NOTE:
The database requires the Microsoft Speech Object Library reference which has been in all versions of Windows since XP if not before.
If the reference is missing, check you have Speech Recognition enabled in Windows Control Panel / Settings
Attached Images
File Type: png Text2Speech.png (26.5 KB, 428 views)
Attached Files
File Type: zip Text2Speech.zip (42.6 KB, 120 views)

__________________
Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
, Tapatalk


If this answer has helped, please click the Thanks button and/or click the 'reputation' scales symbol on the left and leave a comment. Cheers!

Last edited by ridders; 10-02-2017 at 04:02 AM.
ridders is offline   Reply With Quote
The Following 3 Users Say Thank You to ridders For This Useful Post:
jdraw (10-01-2017), Minty (10-02-2017), Peter Reid (10-02-2017)
Old 10-01-2017, 08:33 PM   #2
arnelgp
Newly Registered User
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 4,736
Thanks: 50
Thanked 1,579 Times in 1,505 Posts
arnelgp has a spectacular aura about arnelgp has a spectacular aura about arnelgp has a spectacular aura about
Re: Text to Speech Example Database

In excel

Application. Speech. Speak "hello "
__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
Old 10-02-2017, 04:01 AM   #3
ridders
AWF VIP
Gold Supporter
 
ridders's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 2,923
Thanks: 54
Thanked 686 Times in 634 Posts
ridders has a spectacular aura about ridders has a spectacular aura about
Re: Text to Speech Example Database

As with a lot of things, TTS is easier to do in Excel than Access

To read the contents of cell A1 in Excel, you would just do this:

Code:
Private Sub TTS()

    Dim strText As String
    
    strText = Workbooks("Book1").Sheets("Sheet1").Range("A1")
    
    Application.Speech.Speak strText, 0, 0, -1

End Sub
For more info on TTS in Excel, see this link (which I believe is where arnelgp got his example from):
https://msdn.microsoft.com/VBA/Excel...k-method-excel

__________________
Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
, Tapatalk


If this answer has helped, please click the Thanks button and/or click the 'reputation' scales symbol on the left and leave a comment. Cheers!
ridders is offline   Reply With Quote
Reply

Tags
text to speech

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
DEMO - Text to speech example database ridders Modules & VBA 0 09-13-2017 01:47 PM
Voice Welcome and Warning Messages.. (Text To Speech) Taruz Sample Databases 0 11-27-2011 09:42 AM
Bush's Resignation Speech Joe8915 Politics & Current Events 11 10-09-2008 06:49 PM
Activate Dialer and Text to Speech hooi General 0 10-14-2003 11:47 PM




All times are GMT -8. The time now is 02:11 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World