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.
===========================================================================
