Trims akan saya coba perbaiki
----- Original Message -----
From: hari yanto
To: [email protected]
Sent: Wednesday, April 07, 2010 7:31 PM
Subject: Re: [belajar-access] DATA TABEL
Coba sintaxnya diperbaiki seperti ini:
VARA = DLookup("COIL_ OK", "T_PRODUCTION_ FIGURE", "TANGGAL=#" &
Forms!F_PRODUCTION_ MASTER!TANGGAL & "#")
Mohon dicek juga format textbox tanggal pada form. Harus menggunakan
date pula....
Mungkin ini bisa membantu...
--- On Wed, 7/4/10, Maulana <[email protected]> wrote:
From: Maulana <[email protected]>
Subject: [belajar-access] DATA TABEL
To: "access" <[email protected]>
Date: Wednesday, 7 April, 2010, 2:49 PM
Dear All
ada sintax sperti ini tapi kenapa y tidak bisa tampil pada
textbox yang di inginkan
ada textbox data diambil dari tabel
Private Sub TANGGAL_LostFocus( )
Dim VARA As Variant
VARA = DLookup("COIL_ OK", "T_PRODUCTION_ FIGURE", "TANGGAL=#" &
Forms!F_PRODUCTION_ MASTER!TANGGAL & "#")
GROSS_PRODUCTION_ PCS_TODAY = VARA
End Sub
Salam
MAulana
------------------------------------------------------------------------------
New Email names for you!
Get the Email name you've always wanted on the new @ymail and @rocketmail.
Hurry before someone else does!
