# cek query tadi di accessnya, kalau benar ->
# cek nilai dtpicker1.value, kalau benar ->
# cek object rs setelah open, dia statusnya null recordset bukan
(jika operasi logika (rs.EOF and rs.BOF) = true)
regards
[wwn]
On 9/21/05, ryu_hanazawa <[EMAIL PROTECTED]> wrote:
--- In [email protected], Purwedi Kurniawan
<[EMAIL PROTECTED]> wrote:
> 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
> >
> >THQYU buat jawabnnya, tapi script itu msh jg ga bisa, tetep blank
tampilan di flexgridnya.
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.
