Me.txtCount = DCount("[NoPcs]", "[T_Card_A_Detail]", "ID_PDP= " & NomorPDP & "
AND [Standart] = True")
ID_PDP tipenya teks ? kalau numeric seharusnya ini udah benul. kalau text, maka
harusnya bagian kriteria ketambahan apostrof tunggal:
"ID_PDP= '" & NomorPDP & "' AND [Standart] = True"
aksan kurdin
--- In [email protected], "noorshiam" <noorsh...@...> wrote:
>
> Terima kasih infonya,
> tapi kelihatannya malah error tuh? Apa mas SukaAccess sudah coba? :-P
>
> --- In [email protected], suka access <suka.access@> wrote:
> >
> > kayaknya kurang kutip aja tuh
> >
> > "[Standart]" =" True")
> >
> >
> >
> > Private Sub Form_Current()
> > NomorPDP = Me.ID_PDP.Value
> > Me.txtCount = DCount("[NoPcs]", "[T_Card_A_Detail]", "ID_PDP= " &
> > NomorPDP & " AND "[Standart]" =" True")
> > End Sub
> >
> >
> >
> > suka.access
> >
> > 2010/6/18, noorshiam <noorshiam@>:
> > > Dear All,
> > >
> > > Saya ada script seperti ini :
> > > Private Sub Form_Current()
> > > NomorPDP = Me.ID_PDP.Value
> > > Me.txtCount = DCount("[NoPcs]", "[T_Card_A_Detail]", "ID_PDP= " &
> > > NomorPDP & " AND [Standart]=True")
> > > End Sub
> > >
> > > Maksud saya, field txtCount pada form tersebut berisi jumlah record yang
> > > criterianya ID_PDP = Me.ID_PDP AND Standart = True
> > >
> > > Masalahnya, pada saat dijalankan kenapa criteria yang terbaca hanya
> > > Standart
> > > = True saja?? Sementara ID_PDP tidak dianggap. Apakah ada yang salah
> > > dengan
> > > syntax DCount?
> > >
> > > Mohon pencerahan
> > >
> > > Terima Kasih
> > > Salam
> > >
> > > Arief Noorshiam
> > >
> > >
> >
>
