kayaknya harus pakai ## deh... select * from member where tgl>=#" & format(reg.value,"mm/dd/yyyy") & "# gak tau deh bener ato gak....uda lama gak pakai access....just try aja :D
Best Regards, Fanry IT Staff PT. Dynea Indria Kawasan Industri Pulogadung No 22 -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of opie Sent: Thursday, February 09, 2006 6:55 PM To: [email protected] Subject: [indoprog-vb] Query tanggal di Access melalui VB? Halo, mau nanya nih aku pake VB dgn Access aku coba query... 1. select * from member where tgl>='" & reg.value & "' 2. select * from member where tgl>='" & format(reg.value,"mm/dd/yyyy") & "' dua macam query ini sll muncul error "Data type mismatch in criteria" masalahnya dimana ya? di Access aku pake short date reg itu adalah dtpicker terima kasih salam Opie [Non-text portions of this message have been removed] Untuk berhenti berlangganan kirim email kosong ke : [EMAIL PROTECTED] Ikuti juga forum diskusi VB.net dengan mengirim email kosong ke [EMAIL PROTECTED] Yahoo! Groups Links Untuk berhenti berlangganan kirim email kosong ke : [EMAIL PROTECTED] Ikuti juga forum diskusi VB.net dengan mengirim email kosong ke [EMAIL PROTECTED] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indoprog-vb/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
