CharlesWhiteman
Registered User.
- Local time
- Today, 16:00
- Joined
- Feb 26, 2007
- Messages
- 421
I'm using the following code which successfully allows me to send a contact a SMS message from a MS Access Form.
I'm haivng a problem trying to get the code to look at a table and send an sms message row. The error i get is: Microsoft Visual Basic Compile Error: ByRef argument type mismatch
I am successfully using the code where the smsnumber and message are textboxes in a form. I'm trying to get this to look at a table containing multiple messages to send.
I'm haivng a problem trying to get the code to look at a table and send an sms message row. The error i get is: Microsoft Visual Basic Compile Error: ByRef argument type mismatch
I am successfully using the code where the smsnumber and message are textboxes in a form. I'm trying to get this to look at a table containing multiple messages to send.
Code:
Set mydb = CurrentDb()
Set rs = mydb.OpenRecordset("TblSmsMessages", dbOpenSnapshot)
With rs
.MoveFirst
Do Until rs.EOF
If IsNull(rs.Fields(2)) = False Then
SkypeSMS SmsNumber, SMSMessage
End If
.MoveNext
Loop
End With
rs.Close
Set mydb = Nothing
Set rs = Nothing
End Sub