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

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 6

Visit Your Group

SPAM IS PROHIBITED

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___