Results 1 to 4 of 4
  1. #1
    CHEECO is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Feb 2016
    Posts
    156

    make access work with text to speech

    I am trying to make access work with text to speech. The below code is a code I use with excel to di it. It is not a big deal but I would like to get this to work in access also. What changes do I need to make to the code to get it to work with access as well. Thank-you

    Cheeco

    Code:
    Sub UseSpeech()
     
     Application.Speech.Speak "type the words to say here"
     
    End Sub


  2. #2
    nhorton79 is offline Advanced Beginner
    Windows 8 Access 2007
    Join Date
    Apr 2015
    Posts
    34
    Try a variation of:
    Sub test()
    Dim s As Object
    Set s = CreateObject("SAPI.SpVoice")
    s.Speak "Greetings. How are you?"
    Set s = Nothing
    End Sub

  3. #3
    CHEECO is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Feb 2016
    Posts
    156
    That worker perfectly. Thanks.

  4. #4
    nhorton79 is offline Advanced Beginner
    Windows 8 Access 2007
    Join Date
    Apr 2015
    Posts
    34
    Glad I could help.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 01-09-2018, 01:14 AM
  2. Has anyone got a template for a Music, Speech and Drama Festival?
    By Steve Hughes in forum Sample Databases
    Replies: 4
    Last Post: 01-16-2015, 08:57 AM
  3. Replies: 17
    Last Post: 04-24-2013, 12:58 PM
  4. Make-shift Work rota in Access
    By jimmy2 in forum Database Design
    Replies: 4
    Last Post: 12-30-2012, 02:29 AM
  5. Replies: 2
    Last Post: 05-22-2012, 03:29 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums