coba sebelum perintah itu, test string kriteria dengan perintah : debug.print "ID_PDP= " & NomorPDP & " AND [Standart] = True"
bagaimana hasilnya ? valid string ? aksan kurdin --- In [email protected], "noorshiam" <noorsh...@...> wrote: > > ID_PDP tipenya numeric Bang, harusnya sudah betul kan ?? koq masih belum bisa > ya??? > > --- In [email protected], "aksankurdin" <aksan.kurdin@> wrote: > > > > 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" <noorshiam@> 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 > > > > > > > > > > > > > > > > > > > >
