coba dirubah tanda kutip tunggal (') mejadi tanda pagar(#) untuk
access.
cn.Execute "update tbl_perdana set flag='Expire' where tgl_expire <
#" & DTPicker1.Value & "#"
F
in Code we trust...
--- In [email protected], McBoenBoen <[EMAIL PROTECTED]> wrote:
>
> 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.
>
> [Non-text portions of this message have been removed]
>
