Fw: [belajar-access] Tanya Soal DCount

 

----- Original Message -----

From: "suka access" <suka.access@gmail.com>

To: <belajar-access@yahoogroups.com>

Sent: Friday, June 18, 2010 3:09 PM

Subject: Re: [belajar-access] Tanya Soal DCount

> 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@yahoo.com>:
> > 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
> >
> >
>
>
> ------------------------------------
>
> SPAM IS PROHIBITEDYahoo! Groups Links
>
> <*> To visit your group on the web, go to:
>     http://groups.yahoo.com/group/belajar-access/
>
> <*> Your email settings:
>     Individual Email | Traditional
>
> <*> To change settings online go to:
>     http://groups.yahoo.com/group/belajar-access/join
>     (Yahoo! ID required)
>
> <*> To change settings via email:
>     belajar-access-digest@yahoogroups.com
>     belajar-access-fullfeatured@yahoogroups.com
>
> <*> To unsubscribe from this group, send an email to:
>     belajar-access-unsubscribe@yahoogroups.com
>
> <*> Your use of Yahoo! Groups is subject to:
>     http://docs.yahoo.com/info/terms/
>