kalu access, tanggal itu harus diapit dengan tanda # jadi kira2 begini : cn.Execute "update tbl_perdana set flag='Expire' where tgl_expire < #" & DTPicker1.Value & "#"
======================= http://www.fire888.com -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of McBoenBoen Sent: Wednesday, May 30, 2007 4:59 PM To: [EMAIL PROTECTED]; [email protected]; Waroeng VB Subject: [Programmer-VB] Cari tgl Expire Dear All, mohon pencerahan, bagaimana caranya update field Flag dengan membandingkan field tgl_expire dengan tanggal inputan. saya coba tapi masih error... berikut scripnya.. cn.Execute "update tbl_perdana set flag='Expire' where tgl_expire < '" & DTPicker1.Value & "'" tgl_expire=date/time database=Access 2003 terimakasih atas pencerahannya salam, mc ---------------------------------------------------------------------------- -- Got a little couch potato? Check out fun summer activities for kids.
