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