Search results

  1. S

    Using Twilio with Access to send & receive text & voice messages

    I see that you are using Twimlets. Does that require the user to set it up on the Twilio account or is that just the URL that you hit with the POST message? Thanks :) No, it's just a form that I set to popup. I figured out where the bottom right of the Access screen is using: h =...
  2. S

    Using Twilio with Access to send & receive text & voice messages

    Ok and how did you modify the SMS send code to enable sending voice messages? Sure. I've attached images of the Inbox as well as the notification. The latter is on a 3 second transparancy fade in/fade out. I browsed through it and it looks great! I'll check it out when I have a chance.
  3. S

    Using Twilio with Access to send & receive text & voice messages

    Hi Colin I don't get why it works for you but not for me! I did solve this, though. More about that later. I note that you are receiving voice messages as well. Is there documentation somewhere that is compatible with Access VBA users? As I've said, Twilio is thoroughly documented but other...
  4. S

    Using Twilio with Access to send & receive text & voice messages

    Unfortunately, that didn't work :( I tried after the //api.twilio.com part and the application just froze up completely. Thank you
  5. S

    Using Twilio with Access to send & receive text & voice messages

    Hi Gasman Thanks for your reply. This is a first for me using MSXML GET so it's a bit of a learning curve:) You are suggesting that I put a ? after the URL. In Colin's example, I am using the URL "https://api.twilio.com/2010-04-01/Accounts/" & ACCOUNTSID & "/SMS/Messages.csv" in this case...
  6. S

    Using Twilio with Access to send & receive text & voice messages

    Upon further reading, it seems that the protocol caches the results somewhere and doesn't release the cache until the application is restarted. I see posts about sending a random URL request to clear the cache. Does anyone know about this? It's likely this is the problem.
  7. S

    Using Twilio with Access to send & receive text & voice messages

    I've spent the past month or so building a fancy interface around the code that Colin posted to receive messages and I am just realizing that I have a problem. I earlier reported that it's taking 10 or more minutes for the messages to be received but I now realized that one I click the receive...
  8. S

    Using Twilio with Access to send & receive text & voice messages

    In case someone else is using this thread as a reference: The time stamp in the downloaded logs from Twilio is in UTC. If you are in the UK that is not a problem, but I am in Canada. I was able to overcome this by implementing the functions I found here...
  9. S

    Using Twilio with Access to send & receive text & voice messages

    String to date conversion works perfectly. Thanks once again!
  10. S

    Using Twilio with Access to send & receive text & voice messages

    I am not understanding how you convert from their format to a Date/Time. When it's imported, what format does it come into the table as? I'm importing it as Text and then trying to convert it to a date/time but really no luck. I've tried using DateSerial and all kinds of string functions to...
  11. S

    Using Twilio with Access to send & receive text & voice messages

    So, some questions: 1) How do you construct the URL to filter dates? I see you do it there but I don't know the syntax. I suppose the best way to do it is to keep a stamp in the database for the latest download date/time so i can tell it to only import transactions since then. 2) Have you...
  12. S

    Using Twilio with Access to send & receive text & voice messages

    Ok my bad! If you look at the code, there is no / between the ACCOUNTSID and "SMS", so it sent it off as one string! I should have scrutinized that more carefully. Anyway, it worked and a HUGE thank you for the assistance! Another tip: it actually comes back in XML and I don't mind writing a...
  13. S

    Using Twilio with Access to send & receive text & voice messages

    I have NO idea how you figured that out but I really appreciate it! The message I'm getting back is an XML message that the AccountSid or AuthToken was incorrect. I am using the same info as I used for the send! I am using a trial account which is pretty limited. Do you happen to know if...
  14. S

    Using Twilio with Access to send & receive text & voice messages

    That's actually the post that got me going with being able to send messages, but I didn't see anything there for receiving. My problem is that I don't know how to adapt the syntax for Twilio, specify the download format, specify where it gets downloaded to and so on. I really don't have much...
  15. S

    Using Twilio with Access to send & receive text & voice messages

    I am interested in using Twilio. I found a blog post with code to send messages so setting up an account and making a form that sends messages took all of 20 minutes. However, I have no understanding of how to use GET as you described to download the responses. Would you mind posting your code...
  16. S

    Can I link an Access database in Drupal?

    I am not clear on the specific concern about version. Assuming that you want all users to have the same version of the FE when it gets revised, a solution that's worked for me that is very simple is to put a shortcut to a batch file in the startup folder of each client computer. So, assuming...
  17. S

    MS Access vs other tecnologies

    Well, the way I tested it was by simply creating a new form with a button that has the code: dim i as integer i = "foobar" And then run it, to force a Type Mismatch. I clicked Debug, changed the line to i = 5 and then the arrow and it continued just fine.
  18. S

    MS Access vs other tecnologies

    Ahh....interesting. I didn't get that from the original message. I tried it and it works. Thank you
  19. S

    MS Access vs other tecnologies

    I forced an error to see what you mean and the choices are "End", "Debug" and "Help". What do you mean by bypass the error and press Go? SHADOW
  20. S

    MS Access vs other tecnologies

    Actually, I comprehend almost nothing of this post :) I wouldn't even know what background information to start reading in order to make sense of it! I'll stick with declaring db = CurrentDB when the program loads to set my global variable based on your final remark, even though you said that...
Back
Top Bottom