ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Crystal Reports, ODBC & Access >> ODBC General Issues >> Evo Reminders
http://www.istechforum.com/YaBB.pl?num=1377888419

Message started by Kelloggs on 08/30/13 at 11:46:59

Title: Evo Reminders
Post by Kelloggs on 08/30/13 at 11:46:59

So how the IS_REM_EXTRA field works??
It holds the customer id and phone number?
How many characters??

do you know?

Private Sub evo_rem()
Dim the_date As String
Dim the_time As String
Dim the_etime As String

the_date = Format(Me.cust_epd.Value, "YYYY-MM-DD")
the_time = Format(Now(), "HH:MM:SS")
the_etime = Format(DateAdd("h", 4, Now()), "HH:MM:SS")

var_sql = "INSERT INTO ISREMIND (" & _
" IS_REM_DATE, " & _
" IS_REM_TIME," & _
" IS_REM_WHO, " & _
" IS_REM_SUBJECT, " & _
" IS_REM_CO, " & _
" IS_REM_EDATE, " & _
" IS_REM_ETIME, " & _
" IS_REM_ENDTM, " & _
" IS_REM_BEFTXT, " & _
" IS_REM_TYPE, " & _
" IS_REM_NOTE, " & _
" IS_REM_CUST, " & _
" IS_REM_EXTRA) " & _
" VALUES ('" & the_date & "','" & the_time & "','JOHN','My Subject','B','" & the_date & "','" & the_time & "','" & the_etime & "','4','CPA','Note','" & Trim(Me.Parent!cust_id.Value) & "','" & Trim(Me.Parent!cust_phone.Value) & "')"
dba_conn (var_sql)
End Sub

>:(

Kelloggs

Title: Re: Evo Reminders
Post by NovaZyg on 09/05/13 at 16:15:48

If it is using Contact Master DB instead of Customer

IS.REM.EXTRA pos 1 - 2 "CM" or " "
IS.REM.EXTRA Pos 3 to 32 is Contact Name
IS.REM.EXTRA Pos 33 to 47 is Phone Number

Title: Re: Evo Reminders
Post by Kelloggs on 09/23/13 at 12:27:27

Thanks Allen

;)