expresi where memang harus mencantumkan sumber asal data filternya. Kalau dari form harus mencantumkan form kalau dari subform harus mencantumkan subform dan formnya, Memang harus seperti itu
Salam, Nino ----- Original Message ----- From: Nana Supriatna To: [email protected] Sent: Friday, April 17, 2009 2:53 PM Subject: Re: [belajar-access] DlookUp yang inconsistent Mungkin... :) ----- Original Message ----- From: [email protected] To: [email protected] Sent: Friday, April 17, 2009 1:20 PM Subject: Re: [belajar-access] DlookUp yang inconsistent Kode barang di form yang aktif itu field. OK Mas sudah bisa dengan memakai ekspressi : =DLookUp("[TableNamaBarang]![NamaBarang]","[TableNamaBarang]","[TableNamaBarang]![KodeBarang] =Forms![FormBarang]![KodeBarang]") dengan penambahan expressi Forms![FormBarang]!. Berarti kalau begitu harus ditambahkan expressi nama form, ya Pak ? regard "Nana Supriatna" <[email protected]> Sent by: [email protected] 04/17/2009 11:31 AM Please respond to belajar-access To: <[email protected]> cc: Subject: Re: [belajar-access] DlookUp yang inconsistent Penggunaan DLOOKUP itu harus sering2 di coba. Baru nanti ketahuan salahnya dimana. KodeBarang ini field atau cuma sekedar textbox ?. Kalau tidak salah ada beda sedikit penulisannya .. Sudah lihat contoh di HELP MS Access ? Coba bandingkan dengan yg dibuat. Salam ----- Original Message ----- From: [email protected] To: [email protected] Sent: Friday, April 17, 2009 11:12 AM Subject: Re: [belajar-access] DlookUp yang inconsistent Saya tidak mencoba combo box karena memang designnya memerlukan DlookUp karena banyak hal-hal yang membutuhkan DlookUp bukan Combobox. Apakah ada yang salah expressionnya di DlookUp? Bisakah di koreksi mana expressi yang benar ? Saya pakai expressi : =DLookUp("[TableNamaBarang]![NamaBarang]","[TableNamaBarang]","[TableNamaBarang]![KodeBarang] = [KodeBarang]") Saya coba merubah nama Primary key di TableNamaBarang dengan KodeBarangTwo, dan hasilnya baru bisa. Tapi apakah harus beda ? Database terlampir : Trims jawabannya. Teguh JAP <[email protected]> Sent by: [email protected] 04/17/2009 08:13 AM Please respond to belajar-access To: [email protected] cc: Subject: Re: [belajar-access] DlookUp yang inconsistent Udah coba pake combo box blm ? 2009/4/16, [email protected] <[email protected]>: > Dear Para Suhu Access, > > Saya mencoba membuat Database sederhana, (Contoh Database terlampir) yaitu > dengan membuat form yang mana diambil dari TableBarang dan > > TableNamaBarang dengan relationship 1-many, yaitu kode barang di > TableBarang diambil dari TableNamaBarang. Tapi waktu saya ingin buat text > box > > untuk menampilkan nama barang di form tersebut dengan pakai DlookUp, itu > ternyata hanya menangkap nama barang yang pertama saja . > > Pertanyaannya : > > 1. Bagaimana untuk mengatasi masalah ini ? > > 2. Mana cara yang praktis dan Cepat memakai DlookUp atau SubForm ? > > > > > Terima kasih jawabannya. > > regard, > Tio > > =========================================================================== > 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. > =========================================================================== > =========================================================================== 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. =========================================================================== =========================================================================== 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. =========================================================================== ------------------------------------------------------------------------------ No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.287 / Virus Database: 270.11.59/2063 - Release Date: 04/16/09 16:38:00
