Re: [belajar-access] Update isi field tabel

 

Halo Kang Andri, maaf saya agak kesulitan beri samplenya. Tapi kira2 spt ini Kang:

 

DoCmd.SetWarnings False
DoCmd.OpenQuery "NamaQueryUpdatenya"
DoCmd.SetWarnings True

Jadi kuncinya di query update tsb. Nah, untuk update via query, harus dijoin ke field primary key. Bila tidak, query update tidak bisa jalan. Sebenarnya bisa juga update via VBA menggunakan DAO. Silahkan dikirim sample Access nya ke milis ini, karena saya tidak bisa uji coba bila tidak ada samplenya. Hanya saja jawabnya ngga bisa cepat, cari waktu luang, he..he.. SIlahkan teman2 mungkin ada yg bisa share, dipersilahkan....

 

Wassalaamu'alaikum Warahmatullahi Wabarakatuh,
Sofyan Efendi
http://imopi.wordpress.com | http://trendmuslim.com

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

From: Trisna Mukti Andri

To: belajar-access@yahoogroups.com

Sent: Thursday, September 13, 2012 3:22 PM

Subject: RE: [belajar-access] Update isi field tabel

Maaf Pak Sofyan maaf kira-kira script code bagaimana ya? (maaf maklum pak…newbie…)

 

Thx

Andri

 

From: belajar-access@yahoogroups.com [mailto:belajar-access@yahoogroups.com] On Behalf Of Sofyan Efendi
Sent: Thursday, September 13, 2012 2:26 PM
To: belajar-access@yahoogroups.com
Subject: Re: [belajar-access] Update isi field tabel

 

 

Dear Pak Trisna, bisa diwujudkan menggunakan query update yg dijalankan via VBA (class module form tsb).

 

Wassalaamu'alaikum Warahmatullahi Wabarakatuh,
Sofyan Efendi
http://imopi.wordpress.com | http://trendmuslim.com

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

From: Trisna Mukti Andri

To: belajar-access@yahoogroups.com

Sent: Thursday, September 13, 2012 1:39 PM

Subject: [belajar-access] Update isi field tabel

 

Dear all,

Bagaimanakah Update isi field tabel A via form dgn data tabel B, mohon bantuannya

 

Thx

andri

---

No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2193 / Virus Database: 2437/5239 - Release Date: 08/31/12
Internal Virus Database is out of date.

__._,_.___

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

Messages in this topic (4)

Recent Activity:

• New Members 5

Visit Your Group

SPAM IS PROHIBITED

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

.

__,_._,___