coba dirubah menjadi spt 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
qsql = "Delete from tblsend where Tanggal BetWeen #" & Format(txtTgl,
"mm-dd-yyyy") & "# And #" & Format(txtTgl2, "mm-dd-yyyy") & "#"
cn.Execute qsql
cn.CommitTrans
rgds
[wwn]
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....
------------------------ Yahoo! Groups Sponsor --------------------~-->
Fair play? Video games influencing politics. Click and talk back!
http://us.click.yahoo.com/T8sf5C/tzNLAA/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/
Untuk keluar dari millis ini, kirim email kosong ke:
[EMAIL PROTECTED]
YAHOO! GROUPS LINKS
- Visit your group "Programmer-VB" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
