[Attachment(s) from Sumiyanto Surabaya included below]
From: harry siswanto <hsiswanto@yahoo.com>
To: Belajar Access <belajar-access@yahoogroups.com>
Sent: Wednesday, 19 June 2013 4:42 PM
Subject: [belajar-access] Fw: tanya Dlookup [1 Attachment]
aturan DLookup;
Look up the _____ field, from the _____ table, where the record is _____
sample;
=DLookup("CompanyName", "Company", "CompanyID = " & [CompanyID])
=DLookup("CategoryName", "Cat", "Category = '" & [Category] & "'")
=DLookup("CategoryName", "Cat", "Date = #" & [Date] & "#")
untuk kasus bang harry, bisa dibuatkan event after update;
Text6.Value = DLookup("serialNO", "T_MasterPC", "PCID = '" & Forms!T_Transaksi!Combo4 & "'")
Thank you | Terima Kasih | Matur Suksema
Sumiyanto
Sumiyanto
From: harry siswanto <hsiswanto@yahoo.com>
To: Belajar Access <belajar-access@yahoogroups.com>
Sent: Wednesday, 19 June 2013 4:42 PM
Subject: [belajar-access] Fw: tanya Dlookup [1 Attachment]
Dear Senior
saya masih bingung dengan menggunakan Dlookup,
untuk mengambil nilai dari suatu Table atau Query
bisa minta tolong dibantu dari contoh terlampir
Terimakasih atas perhatian dan kerjasamanya
<<tanya_DLookup.zip>>
Terimakasih atas perhatian dan kerjasamanya
Harry
__._,_.___
Attachment(s) from Sumiyanto Surabaya
1 of 1 File(s)
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (3) |
SPAM IS PROHIBITED
.
__,_._,___
Tidak ada komentar:
Posting Komentar