[AccessD] Sending a Text Message From Access

Hi Charlotte

And - some years later - you learned how to open a recordset and append records, right?

/gustav


>>> cfoust at infostatsystems.com 07-08-2009 19:42 >>>
Also depends on what version of Access he's using.  But I've built
textfiles from Access in the past using nearly identical code to VB6.

Charlotte 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com 
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters
Sent: Friday, August 07, 2009 10:27 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Sending a Text Message From Access

Thanks Gustav!

I didn't read the code myself - just saw that it could be done!  Maybe
he wrote this last Friday?

Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com 
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Friday, August 07, 2009 12:08 PM
To: accessd at databaseadvisors.com 
Subject: Re: [AccessD] Sending a Text Message From Access

Hi Dan

Interesting yes. This guy builds a simple text file by creating a temp
table, executing a dozen of SQL insert queries to create a record for
each line of text, and exporting the table to create the text file ... 
I nearly forgot - it is Friday.

/gustav


>>> dwaters at usinternet.com 07-08-2009 17:39 >>>
This is interesting!

http://accesstips.datamanagementsolutions.biz/ftp_sms.htm 

Dan