Here's what I'm trying to do:
I am trying to take a customer's mobile (cellphone) telephone number and a text message to create a table that will be exported to our SMS (short messageing service) sending application.
When on the customer’s record to whom the message is to be sent, the user clicks a button, which opens a form.
The form opens, and the user can select from a range of standard messages from a combo box. On selection, the contents of the combo box are copied to a text box below for further editing if required.
Dim A As String
A = [Forms]![form_msg]![Combo1].Text
Me.Msg.Format = Text
Me.Msg = A
Me.Refresh
On clicking the "send" command button, the query to create a new table is run, containing the customer's reference number and mobile telephone number (from the main table in the database) along with the contents of the text box containing the message.
SELECT Maintable.[Mobile Tel], [forms]![form_msg]![msg] AS Msg, Maintable.[Customerref] INTO msg_to_send
FROM Maintable
WHERE (((Maintable.[Customerref])=[Forms]![Maintable]![Customerref]));
Everything works, but the data type in the new table is set to binary not text and so is not understood by the SMS sending application.
I’ve searched the forums and also the helpfile, where Microsoft tell me that binary is not supported natively in Access 2000, only for tables imported from other database applications that do support binary (!)
Can anyone shed any light on this please? I hope it’s something simple!
Thanks in advance.
I am trying to take a customer's mobile (cellphone) telephone number and a text message to create a table that will be exported to our SMS (short messageing service) sending application.
When on the customer’s record to whom the message is to be sent, the user clicks a button, which opens a form.
The form opens, and the user can select from a range of standard messages from a combo box. On selection, the contents of the combo box are copied to a text box below for further editing if required.
Dim A As String
A = [Forms]![form_msg]![Combo1].Text
Me.Msg.Format = Text
Me.Msg = A
Me.Refresh
On clicking the "send" command button, the query to create a new table is run, containing the customer's reference number and mobile telephone number (from the main table in the database) along with the contents of the text box containing the message.
SELECT Maintable.[Mobile Tel], [forms]![form_msg]![msg] AS Msg, Maintable.[Customerref] INTO msg_to_send
FROM Maintable
WHERE (((Maintable.[Customerref])=[Forms]![Maintable]![Customerref]));
Everything works, but the data type in the new table is set to binary not text and so is not understood by the SMS sending application.
I’ve searched the forums and also the helpfile, where Microsoft tell me that binary is not supported natively in Access 2000, only for tables imported from other database applications that do support binary (!)
Can anyone shed any light on this please? I hope it’s something simple!
Thanks in advance.
