Kayaknya sudah ada kemajuan tapi masih ada error ketika di jalankan error
menunjuk Me.PO_Suplyer_ID
Apakah kalau di Perintah SQL tidak bisa ya mengenali me.
Berikut kode yang saya buat
Moho pencerahan
currrentdb.Execute " INSERT INTO General_ledger(transaksion_id, " _
& " gl_number, " _
& " gl_description, " _
& "date, " _
& " posting, " _
& " posting_to, " _
& " description,value) " _
& " values " _
& " & if(" & DLookup([transaksion_id], [general_ledger],
CInt(Left([transaksion_id], 3) = " & PDP & ")) > 0 & " then NOPDP Else
PDP_PERTAMA end if)) & , " _
& " " & DLookup([GL_Number], [po_pd_posting], [ID] = 1),
DLookup([GL_Description], [po_dp_posting], [ID] = 1) & ", " _
& " " & Now & ", " _
& " " & Me.PO_Number & "," & Me.PO_Suplyer_ID & " , " _
& " Down Payment & " & uchase(Me.PO_Number) & " , " _
& " " & sum(rst!Down_Payment) & " "
Salam
Yokanan wahyono
