Ada 2-field (dua2'nya TextBox yg isinya tgl & udah pake pake format
as medium date - setting lewat properties).
Field1 - isinya tgl awal {pake format medium date}
Field2 - isinya tgl akhir [tgl di-sini harus lebih besar or = dengan
tgl awal]. Yg di-field 2 saya udah buat create validation rule
pake 'expression builder' sbb:
>= [Field1] Or Is Null
Nah waktu form'nya saya jalanin -- waktu field2 tglnya = field1
access nggak happy alias error msg (saya pake validation text).
Saya coba 'akalin' field-2nya {validation-rule} pake:
=DateDiff("d",[DateReceived],[DateCompleted])>-1
Bisa jalan waktu tgl di-field1 = field2 -- TAPI ---
waktu tgl field2 saya masukin < field1 system tetep accept.
Saya juga coba ngelmu sama bang-google and dia bilang kudu di-"kilik"
lewat VBA. Nah berhubung saya masih ingusan untuk VBA (skarang lagi
belajar) mohon petunjuk & nasihat :)
Thanks.
--- In [email protected], Erwin Sugiawan <[EMAIL PROTECTED]>
wrote:
>
> di field tanggal.........mungkin tersimpan waktu nya juga spt ini
10-11-2007 14:15:33
> kalo spt itu lalukan format(pdate,"dd-mmm-yyyy") sebelum
membandingkan nya
>
>
> Best regard
> Erwin Sugiawan
>
> ----- Original Message ----
> From: apar7788 <[EMAIL PROTECTED]>
> To: [email protected]
> Sent: Monday, November 5, 2007 10:09:44 AM
> 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
>
>
>
> SPAM IS PROHIBITED
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>
