Nation wide text message from access??

[alvarogueva]

UPDATE***SOLVED**

So, JHB actually solved it! I was able to fix the Null, and Now is sending text messages to the direct driver that is selected. WOW AMAZING! Thank you so much all of you guys! you been amazing!!!

THANK YOU!

The only thing left for me to do, is how to add a piece of code where after the message is send, it erases the text message?

 

[The_Doc_Man]

If the message is built in a variable declared inside the subroutine, the text message vanishes when you exit the subroutine. You never need to erase a message; all you need to do is just overwrite the message with a new one.

 

[JHB]

I've made an example in attached database, if someone in the future want to send text message using Twilio.
Remark: You need to sign up at Twilio, for getting an Accountid and an Authority token.