Search results

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

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...

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.

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...

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...

String to date conversion works perfectly. Thanks once again!

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...

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...

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...

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...

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...

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...

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...

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.

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

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

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...

Does anyone have an opinion if there is an advantage of db=currentdb over db = DBEngine(0)(0) or the other way around? SHADOW

That's actually a really good idea. That way I never have to worry about db going out of scope or forcing the initialization. Thanks a lot! SHADOW

I've implemented this technique. It's hard to determine if on its own it helps with performance but it does sound logical. I've been running into a problem, though. - When I'm developing the app, I enter using the good old shift key so I can get into the program. The DB variable doesn't...