YESSS .... IT WORKS ... thanks bos Murid, ur de best ...! --- On Fri, 5/15/09, Murid Belajar Access <[email protected]> wrote:
From: Murid Belajar Access <[email protected]> Subject: Re: [belajar-access] Filter di Form [1 Attachment] To: [email protected] Date: Friday, May 15, 2009, 8:24 AM [Attachment(s) from Murid Belajar Access included below] mas Ari. silahkan dicoba file terlampir. salam, murid access - NRN CL BEW ----- Original Message ----- From: Ari Ferianto To: belajar-access@ yahoogroups. com Sent: Friday, May 15, 2009 14:17 Subject: Re: [belajar-access] Filter di Form Siang mas ...akhirnya berhasil juga membuat sql nya nya menjadi berikut : SELECT [Tbl Sales Code].KODE, [Tbl Sales Code].NAMA, [Tbl Sales Code].AGENCY, [Tbl Sales Code].PROMO, [Tbl Sales Code].CABANG, [Tbl Sales Code].KOTA FROM [Tbl Sales Code] WHERE ((([Tbl Sales Code].KODE) Like ("*" & [forms]![Form1] ![text37] & "*"))); masalah baru muncul ketika saya akan mengganti nilai pada text37 : keluar pesan error muncul : compile error: sub or function dot defined setelah saya saya debug, error ada pada code : Query1 SubForm.Requery berikut code nya : Private Sub Text37_AfterUpdate( ) Query1 SubForm.Requery End Sub apa harus didefiniskan terlebih dahulu ?? mohon pencerahannya mas. __._,_..___ Attachment(s) from Murid Belajar Access 1 of 1 File(s) filter_ari.rar Messages in this topic (8) Reply (via web post) | Start a new topic Messages | Files | Photos | Polls SPAM IS PROHIBITED Change settings via the Web (Yahoo! ID required) Change settings via email: Switch delivery to Daily Digest | Switch format to Traditional Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe Recent Activity 12 New Members Visit Your Group Give Back Yahoo! for Good Get inspired by a good cause. Y! Toolbar Get it Free! easy 1-click access to your groups. Yahoo! Groups Start a group in 3 easy steps. Connect with others. .
