Terimkasih mas Lai Min Feng
sudah resolve
salam,
mc
Lai Min Feng <[EMAIL PROTECTED]> wrote:
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.
---------------------------------
Park yourself in front of a world of choices in alternative vehicles.
Visit the Yahoo! Auto Green Center.
