Re: [belajar-access] Cancel Update Table

Dear Mas Fajrie, pada:

 

& oldQty &

 

Apakah oldQty itu nama field di formnya? Adakah pesan errornya saat menjalankan query ini?

 

Wassalaamu'alaikum Warahmatullahi Wabarakatuh,
Sofyan Efendi.
http://opi.110mb.com/

----- Original Message -----

From: Fajrie Shine

To: Belajar Access

Sent: Wednesday, June 01, 2011 9:57 AM

Subject: [belajar-access] Cancel Update Table [1 Attachment]

 

Dear Master Access Assallamu'alaikum WR.WB Mohon Bantuannya lagi nih untuk cancel update table/ undo record update table saat record di delete vb saya seperti ini Private Sub Form_AfterUpdate() DoCmd.SetWarnings False DoCmd.RunSQL "Update Tbl_Barang SET [Stok Keluar] = [Stok Keluar] + " & Me.Quantity_Barang & " - " & oldQty & " WHERE [KodeBarang] = '" & Me.cb_kode_barang & "'" DoCmd.SetWarnings True End Sub Bagaimana caranya ya??? Terimakasih Wassallamu'alaikum WR.WB

__._,_.___

SPAM IS PROHIBITED

Your email settings: Individual Email|Traditional
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe

__,_._,___