coba gini:
 
Set rs = New ADODB.Recordset
SQL1 = "Select * from ABC where [Date] = #" & DTPicker1.Value & "# "
rs.Open SQL1, con, 1, 3
Set MSHFlexGrid1.DataSource = rs

On 9/21/05, ryu_hanazawa <[EMAIL PROTECTED]> wrote:
Ada yg bisa bantu ga sql searching DATE dr DTPicker ke DB Access(filed
Date) untuk dimunculin di  MshFlexgrid.
AKu udah buat tp kok ga muncul data yg seharusnya (blank), apa ada
kesalahan pd format date-nya? atau salah pd scriptnya?
Yg bs bantu Thqu.

scriptnya:

Set rs = New ADODB.Recordset
SQL1 = "Select * from ABC where Date = #" & DTPicker1.Value & "# "
rs.Open SQL1, con, 1, 3
Set MSHFlexGrid1.DataSource = rs



Untuk keluar dari millis ini, kirim email kosong ke:
[EMAIL PROTECTED]





SPONSORED LINKS
Programmer Indonesia Basic programming language
Computer programming languages Programming languages Java programming language


YAHOO! GROUPS LINKS




Kirim email ke