D
Daniel M
I have a database where i submit an http post based on a serial number i
select in a drop down box. I have another situation where i want to be able
to bulk submit this request. I would like to do a list box where i can scan
in the serial numbers and click a button to parse this out one at a time and
post it.
my current code is basically this:
Private Sub Command16_Click()
msgtextstring = "http://www.ourwebsite.com/login" + "1" + telephonetag +
"&MEssage=*0,01**" + imsntag + "*" + msgstringtag +
"&OA=447800000110&SRR=not-retries"
Dim SQL As String
SQL = "INSERT INTO messages" & "(message,deviceid,imsn,telephone)VALUES('" &
msgstringtag & "','" & DeviceIDtag & "','" & imsntag & "','" & telephonetag &
"')"
DoCmd.SetWarnings False
DoCmd.RunSQL SQL
DoCmd.SetWarnings True
wbbWebsite.Navigate URL:=msgtextstring
Form_sendsms.Text48.Requery
....so i submit the post, insert the commands sent into my table, and refresh
my wbb control to see the response message.
Now i want to be able to do this bulk. the serial numbers are all 9 digits
long and would be entered into a list box
like...12-34567812-21345612-987654...so 12-xxxxxx format in one string. I
know i can parse this out with excel and make it display each serail number
in a new row. can i parse this out to a temp table and run through it or can
i just run through it from the string? Any help would be appreciated. thanks.
select in a drop down box. I have another situation where i want to be able
to bulk submit this request. I would like to do a list box where i can scan
in the serial numbers and click a button to parse this out one at a time and
post it.
my current code is basically this:
Private Sub Command16_Click()
msgtextstring = "http://www.ourwebsite.com/login" + "1" + telephonetag +
"&MEssage=*0,01**" + imsntag + "*" + msgstringtag +
"&OA=447800000110&SRR=not-retries"
Dim SQL As String
SQL = "INSERT INTO messages" & "(message,deviceid,imsn,telephone)VALUES('" &
msgstringtag & "','" & DeviceIDtag & "','" & imsntag & "','" & telephonetag &
"')"
DoCmd.SetWarnings False
DoCmd.RunSQL SQL
DoCmd.SetWarnings True
wbbWebsite.Navigate URL:=msgtextstring
Form_sendsms.Text48.Requery
....so i submit the post, insert the commands sent into my table, and refresh
my wbb control to see the response message.
Now i want to be able to do this bulk. the serial numbers are all 9 digits
long and would be entered into a list box
like...12-34567812-21345612-987654...so 12-xxxxxx format in one string. I
know i can parse this out with excel and make it display each serail number
in a new row. can i parse this out to a temp table and run through it or can
i just run through it from the string? Any help would be appreciated. thanks.