RE: [belajar-access] Table atau query dengan fungsi Look Up.

Private Sub Report_Open(Cancel As Integer)

On Error Resume Next

    LabelPerush.Caption = " " & DLookup("NamaPerusahaan", "MasterPerusahaan")

    LabelAlamat.Caption = " " & DLookup("Alamat", "MasterPerusahaan")

    LabelKota.Caption = " " & DLookup("Kota", "MasterPerusahaan")

    LabelTelp.Caption = " " & DLookup("Telp", "MasterPerusahaan")

End Sub

 

Field Table MasterPerusahaan:

 

MasterPerusahaan
ID	NamaPerusahaan	Alamat	Alamat2	Kota	Telp
KEY	Toko Access Wizards	Senayan	Senayan Plaza	Jakarta Pusat	021-1234567

 

Best Regards,

AccessWizards

 

From: belajar-access@yahoogroups.com [mailto:belajar-access@yahoogroups.com] On Behalf Of Dicky Achmad
Sent: 24 January 2011 13:26
To: belajar-access@yahoogroups.com
Subject: [belajar-access] Table atau query dengan fungsi Look Up.

 

 

Selamat Siang,

Mohon bantuan dan pencerahannya untuk dapat menampilkan report dengan  melihat record tertentu yang ada pada table atau query dengan fungsi Look Up. Terima kasih.

Regards

 

---

 

 

 

__._,_.___

SPAM IS PROHIBITED

Your email settings: Individual Email|Traditional
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe

__,_._,___