Table A : Yang dipindah
Table B : Yang di tuju
1. Buat query append dari TAble A ke TAble B. Nama Query = QueryPindah
(misal)
2. Buat query delete table A. Nama Query = QueryHapus (misal)
3. Buat Command Button :
DoCmd OpenQuery"QueryPindah"
DoCmd OpenQuery"QueryHapus"
regard,
Tio
"vanbredo" <[email protected]>
Sent by: [email protected]
08/11/2009 07:14 AM
Please respond to belajar-access
To: [email protected]
cc:
Subject: [belajar-access] Memindahkan satu data ke tabel lain
dgn perintah
commandbutton
sy membuat commandbutton pindah, didlmnya ada kriteria pindah krn
meninggal dunia, pensiun, pindah ke kab/kota lain dll, gimana cara agar
data tsb bisa pindah ke tabel lain tsb, selama ini saya cut di dbnya dn
paste di tabel lainnya,trims before
===========================================================================
This email is confidential. If you are not the addressee tell the sender
immediately and destroy this email without using, sending or storing it.
Emails are not secure and may suffer errors, viruses, delay, interception
and amendment. The Trakindo Group of Companies do not accept liability for
damage caused by this email and may monitor email traffic.
Unless expressly stated, any opinions are the sender's and are not approved
by the Tiara Marga Trakindo Group of Companies and this email is not an
offer, solicitation, recommendation or agreement of any kind.
===========================================================================
