Di perintah RunCommand.. ada enggak requery? Boleh di test, Requery nya bisa di pakai enggak.
Salam, ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of e...@nt Sent: Friday, October 02, 2009 6:59 AM To: [email protected] Subject: Re: [belajar-access] Setting Multiuser sy sudah coba dgn perintah DoCmd.RunCommand acCmdRefresh tetapi tetap saja data yang dientry komp B tidak dapat tampil di komp A sy jg coba dgn DoCmd.RunCommand acCmdRefreshData tetapi malah error "The RunCommand Action was canceled" jd sy tetep pake metode tutup-buka form, toh prosesnya tidak terlalu keliatan terima kasih 2009/10/2 HENDRA <[email protected] <mailto:[email protected]> > Isi tombol refresh itu tidak perlu menutup form kemudian membukanya kembali, melainkan hanya me refresh data di form tsb. Ini saya copaskan kode hasil dr wizard Private Sub Command79_Click() On Error GoTo Err_Command79_Click DoCmd.RunCommand acCmdRefresh Exit_Command79_Click: Exit Sub Err_Command79_Click: MsgBox Err.Description Resume Exit_Command79_Click End Sub Anda bisa membuat tombol refresh gunakan wizard agar lebih mudah pembuatannya. From: [email protected] <mailto:[email protected]> [mailto:[email protected] <mailto:[email protected]> ] On Behalf Of e...@nt Sent: Friday, October 02, 2009 12:15 AM To: [email protected] <mailto:[email protected]> Subject: Re: [belajar-access] Setting Multiuser sy sudah coba utak-atik, tp tetep blm sesuai yg sy harapkan. akhirnya diakalin spt cara mas Hendra pada form ditambahin tombol refresh yg isinya menutup form itu sendiri & membuka form itu kembali docmd.close acform,"Form1" docmd.openform "Form1" jd kalo komp B sudah entry tp di komp A blm terdeteksi, komp A harus klik tombol refresh tsb. kalo ada solusi yang lain, mohon dishare. terima kasih. salam, e...@nt 2009/10/1 Bambang Mahfudin <[email protected] <mailto:[email protected]> > Klo boleh urun rembug, Prinsibnya sama pakai action Refresh, hanya action Refresh tersebut bisa ditempatkan pada field terakhir suatu data record, sedangkan event yg dipakai adalah " On Exit " Jadi, begitu kita selesai ng-entry data pada satu record, pada saat akan berpindah ke record berikutnya terjadi Refresh atau update data. Tks <BM> ----- Original Message ----- From: HENDRA <mailto:[email protected]> To: [email protected] <mailto:[email protected]> Sent: Thursday, October 01, 2009 10:12 AM Subject: RE: [belajar-access] Setting Multiuser Coba di komp B tambahkan tombol refresh jadi gak usah tutup form dulu biar bisa ngelihat perubahan yg sudah dibuat oleh komp A From: [email protected] <mailto:[email protected]> [mailto:[email protected] <mailto:[email protected]> ] On Behalf Of e...@nt Sent: Thursday, October 01, 2009 8:54 AM To: [email protected] <mailto:[email protected]> Subject: [belajar-access] Setting Multiuser Dear semuanya, Sy mo tanya soal settingan Multiuser database sudah sy pecah FE & BE BE bisa diakses di 2 komputer yang berbeda yg jd pertanyaan : Ketika komp A menambah data, tidak bs otomatis tampil di komp B spy komp B bisa melihat data yg dientry oleh komp A, komp B harus tutup form dulu, baru membukanya kembali begitu juga sebaliknya Gimana solusinya ? Terima kasih. Salam, e...@nt ----------------------------------------- ---------------------------------------------------------- This transmission is CONFIDENTIAL and the information is intended only for the use of the individual or entity to whom it is addressed. If you are not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any use, dissemination, distribution or copying of this communication is STRICTLY PROHIBITED. If you have received the transmission in error, please immediately notify us by email and/or telephone, and delete the transmission and any attachments from your mailbox. Thank you.
