alternatif tambahkan field pada tabelnya Nama Type Resign Yes/No Pindah Yes/No
Ide/Logik di Query bisa gunakan Filtering; Resign = yes, maka akan menampilkan data yg Status Resignnya = yes Pindah = yes, maka akan menampilkan data yg Status pindah nya =yes dari Query tersebut kemudian juga bisa di "Append ke tabel lain" baru kemudian di Delete yg status Resign=Yes dan atau Pindah=yes. monggo dilanjut... regards 2009/8/11 <[email protected]> > > > > 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. > =========================================================================== > > > -- Harry Siswanto Email: [email protected] www.facebook.com/harry.siswanto
