Hello Mas Edy, Code'nya dah jalan.. Stelah saya coba2 ternyata instead of <= 0 pake < -1
Anyway - CASE CLOSED & thanks. --- In [email protected], "Edy WIYONO" <[EMAIL PROTECTED]> wrote: > > gunakan event field2_beforeUpdate() > > > Private Sub FIELD2_BeforeUpdate(Cancel As Integer) > > if field2.value -field1.value <=0 then > msgbox "tanggal sama / lebih awal dari FIELD1" > cancel = true > endif > > End Sub > > > ----- Original Message ----- > From: apar7788 > To: [email protected] > Sent: Monday, November 05, 2007 12:22 > Subject: [belajar-access] Re: MOHON PETUNJUK > > > ada 2 field isinya tgl. > field1 = tgl mulai [format med-date] > field2 = tgl selesai [format med-date] > > output yg di-inginkan, waktu user ng-entry field2 tgl'nya HARUS lebih > besar dari tgl di-field-1 ato NULL. > > saya udah coba kilik lewat form property (validation rule) access > tetep mogok. > > --- In [email protected], "Edy WIYONO" <wedhiaccess@> > wrote: > > > > bisa lebih jelas mas? > > yang dikompare field apa dgn apa, trus hasil yang diharapkan apa. > > > > ----- Original Message ----- > > From: apar7788 > > To: [email protected] > > Sent: Monday, November 05, 2007 10:09 > > Subject: [belajar-access] MOHON PETUNJUK > > > > > > Dear all, > > I got stuck with Access 2003. > > The problem is waktu coba kompare 2-field yg isinya tgl. > > Saya udah coba pake validation rule (lewat form) tapi tetep ga > jalan. > > Nah mohon petunjuk para dukun & master yg bisa guide lewat vba. > > Kulu nuwun & terima kasih. > > Regards, > > Andre > > >
