Page 2 of 2 FirstFirst 12
Results 16 to 28 of 28
  1. #16
    moke123's Avatar
    moke123 is offline Me.Dirty=True
    Windows 11 Office 365
    Join Date
    Oct 2012
    Location
    Ma.
    Posts
    1,879

    Normally you do not open API's, you just access their objects and methods.

    What exactly are you trying to do?
    If this helped, please click the star * at the bottom left and add to my reputation- Thanks

  2. #17
    Jaap's Avatar
    Jaap is offline Advanced Beginner
    Windows 11 Access 2021
    Join Date
    Apr 2017
    Location
    North Holland
    Posts
    64
    What exactly are you trying to do?

    Click image for larger version. 

Name:	Microsoft Speech Object Library.png 
Views:	25 
Size:	115.6 KB 
ID:	52228

  3. #18
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    6,566
    You have already been told. You just add it to references.
    However, if you read that link, as I did, you do not even need to do that, if you just want to speak some phrase.
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  4. #19
    Jaap's Avatar
    Jaap is offline Advanced Beginner
    Windows 11 Access 2021
    Join Date
    Apr 2017
    Location
    North Holland
    Posts
    64
    Thank you all for helping me.

    Ok, I can't look at it until tomorrow morning, I have visitors at home now.
    I really want to get it done, this is quite difficult for me.


    Apologies for the inconvenience. :-(

  5. #20
    Edgar is offline Competent Performer
    Windows 8 Access 2016
    Join Date
    Dec 2022
    Posts
    309
    Jaap, you can play any sound with the method in post #14.

    I'm not sure the text to speech feature includes a synthesized voice that will sound well in your native language, which is not english. Also, you said you wanted to open a DLL file, but why? do you want to play a sound or open a DLL file?
    Please click on the ⭐ below if this post helped you.


  6. #21
    Jaap's Avatar
    Jaap is offline Advanced Beginner
    Windows 11 Access 2021
    Join Date
    Apr 2017
    Location
    North Holland
    Posts
    64
    Quote Originally Posted by Edgar View Post
    Jaap, you can play any sound with the method in post #14.

    I'm not sure the text to speech feature includes a synthesized voice that will sound well in your native language, which is not english. Also, you said you wanted to open a DLL file, but why? do you want to play a sound or open a DLL file?
    Location Windows Media Player
    C:\Program Files\VideoLAN\VLC/vlc.exe

    Location mp3 file
    D:\SoundFile\Snoekbaars.mp3

    Click image for larger version. 

Name:	Enable Soundfile.png 
Views:	22 
Size:	85.6 KB 
ID:	52229

    I thinks working with Speech is better, making choice of Male or Female voice is possible.

  7. #22
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    6,566
    What is wrong with the method linked to in post #2 in this thread?

    We are now up to #22
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  8. #23
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    6,566
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  9. #24
    Jaap's Avatar
    Jaap is offline Advanced Beginner
    Windows 11 Access 2021
    Join Date
    Apr 2017
    Location
    North Holland
    Posts
    64
    Dear Welshgasman, thank you for sending this VBA commands,

    I'm used to work with VAB - Code Builder,

    Then I'm using mainly this kind of simple Commands like:

    Private Sub SaveRecord_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
    On Error GoTo Fout
    DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
    DoCmd.Save acForm, "VisserijF"
    DoCmd.Close
    DoCmd.OpenForm "VisserijF"
    DoCmd.GoToRecord , , acLast
    Fout:
    Exit Sub
    End Sub

    But I don't know how, but also not why I should use the command groups you sent me, I think this is too difficult for me.

    You can also try this method.

    compile error, OpenNativeApp

    1e 'Attribute VB_Name = "modNativeApp"Option Compare Database
    Option Explicit

    but I don't know how and why I should use the command groups you sent me, I think this is too difficult for me.

    2e Public Sub OpenNativeApp(ByVal psDocName As String)Dim r As Long, msg As String

    3e Private Sub Command273_Click()OpenNativeApp "C:\TempFolder"
    End Sub

  10. #25
    Jaap's Avatar
    Jaap is offline Advanced Beginner
    Windows 11 Access 2021
    Join Date
    Apr 2017
    Location
    North Holland
    Posts
    64
    Dear members who helped me, I have found how to enable 'Microsoft Speech Object Library'
    I have also found how to make Microsoft Speech speak in VBA.
    I just need to find out if the spoken words can be pronounced in another language.
    For me this Topic is solved.


    Thanks for all the help.

    Click image for larger version. 

Name:	Microsoft References.png 
Views:	11 
Size:	123.1 KB 
ID:	52239

    Click image for larger version. 

Name:	Speech is working.png 
Views:	12 
Size:	4.9 KB 
ID:	52238

  11. #26
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    6,566
    Well, have you tried another language?

    Code:
    speak "Bonjour madame"
    speak "Buenos Dias Senorita"
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  12. #27
    Jaap's Avatar
    Jaap is offline Advanced Beginner
    Windows 11 Access 2021
    Join Date
    Apr 2017
    Location
    North Holland
    Posts
    64
    Quote Originally Posted by Welshgasman View Post
    Well, have you tried another language?

    Code:
    speak "Bonjour madame"
    speak "Buenos Dias Senorita"
    I hope it is possible to use my own language with Microsoft Speech, with the English language Speech can not pronounce the word 'Fuiken' (Traps) well.
    I want to find out tonight if this is possible?


    I really like working with Microsoft Speech.

    Jaap

  13. #28
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    6,566
    You might have to type the words phonetically?
    However, Google for it in another language. Perhaps if your PC is set to another language, perhaps it will pronounce them?
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 03-10-2021, 10:01 PM
  2. Writing to a text file and linking table to text file
    By NightWalker in forum Programming
    Replies: 17
    Last Post: 07-21-2020, 04:35 PM
  3. Replies: 4
    Last Post: 05-26-2018, 03:02 PM
  4. Replies: 4
    Last Post: 09-09-2015, 12:10 PM
  5. VBA Opening Excel File and Placing Data in Cells
    By BobTHG in forum Programming
    Replies: 0
    Last Post: 01-13-2008, 03:01 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