Begini Aja Bos itu salah di querynya. situ pake Access kan ya? kalo Access hrs begini
qsql = "Delete from tblsend where Tanggal BetWeen #" & Format(txtTgl, > "yyyy-mm-dd") & "# And "# & Format(txtTgl2, "yyyy-mm-dd") & "#" itu untuk tanggal mendingan pake DTPicker aja biar format tanggalnya fix pas mao dirubah ke format "yyyy-mm-dd". kalo ditempat ane itu coding bisa... mudah-mudahan ditempat ente juga bisa. On 9/14/05, Dedy <[EMAIL PROTECTED]> wrote: > guys, dimana letak kesalahan script dibawah ini, > > cn.BeginTrans > qsql = "Delete from tblsend where Tanggal BetWeen '" & Format(txtTgl, > "mm-dd-yyyy") & "' And '" & Format(txtTgl2, "mm-dd-yyyy") & "'" > cn.Execute qsql > cn.CommitTrans > > Error message " Data type mismatch in criteria expression" > saya dah cek di database(ms Access) type data yg saya pakai date/time > kok, kenapa mismatch ya.... > > > > > > Untuk keluar dari millis ini, kirim email kosong ke: > [EMAIL PROTECTED] > > > Yahoo! Groups Links > > > > > > > ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/k7folB/TM --------------------------------------------------------------------~-> Untuk keluar dari millis ini, kirim email kosong ke: [EMAIL PROTECTED] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/Programmer-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/
