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" <[EMAIL PROTECTED]>
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
>
