Access SMS

[DS]

I want to send text messages via Access. I know that I need a provider that
part I have. The problem is what do I put behind the comand button in order
to do this. And can I have this happen automatically, lets say hourly or
every half hour if I so desire. Any help appreciated!
Thanks
DS

 

[Steve Schapel]

DS,

This will likely not provide a total answer to your question, but this
article may be of interest:
http://accesstips.datamanagementsolutions.biz/ftp_sms.htm

 

[DS]

Thanks Steve, I think I get the point now. So can I attach this to a hidden
form with a timer that will execute the code at every specified time
interval? Like an ONTimer Event?
Thanks
DS

 

[Steve Schapel]

DS,

Yes, you could do that on the Timer event of a form, which will of
course need to be open at the time.

Another approach, which may or may not be more suitable, depending on
your usage, could be to use the Windows task manager (or some other
third-party scheduling utility) to set it up as a scheduled task. This
way, you can use a macro in your application to run the SMS export, and
the scheduled task can be used to run the macro.