Coba ubah pada form Table2 Subform:1. Hapus event on load
2. Masukkan prosedur baru di event on current:If IsNull([no]) Or [no] = 0 Then
Me![Total] = 0
Else
Me![Total] = DSum("[Qty]*[harga]", "Query1", "[no] = " & [no])
End If
Ini mungkin bisa membantu.Hariyanto
--- On Thu, 25/6/09, nadhif_fakhri <[email protected]> wrote:
From: nadhif_fakhri <[email protected]>
Subject: [belajar-access] Hasil penjumlahan total pake vba... [1 Attachment]
To: [email protected]
Date: Thursday, 25 June, 2009, 11:47 AM
[Attachment(s) from nadhif_fakhri included below]
Siang...
saya punya program access, hasil pemjumlahannya kok secara total dan bukan
berdasarkan no transaksi, dan hasilnya baru bisa apdate setelah formnya ditutup
dulu....
gimana ya...
maunya pake VBA, tidak menggunakan property ( =sum([jml])
file nya saya lampirkan ...
Maaf di email pertama file blm dilampirkan ...
Terima kasih
Best regards,
nadhif_fakhri
mailto:nadhif_fakhri@ yahoo.co. uk
Get your preferred Email name!
Now you can @ymail.com and @rocketmail.com.
http://mail.promotions.yahoo.com/newdomains/aa/
