wah boleh juga tuh mas...saya mau mas...ditunggu ya kirimannya.....
----- Original Message ----- From: "Gunawan doang" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Thursday, June 15, 2006 1:05 PM Subject: Re: [Programmer-VB] Tanya OCX third party > saya punya tools atau anda bisa juga cari di google dengan key reshack, di mana kita dapat membuat skin mengikuti theme windows xp aktif, tanpa koding tambahan sedikitpun. Tapi saya tools tsb ada di rumah, bila anda mau InsyaAllah besok saya kirim di group ini. > > > indra gunawan <[EMAIL PROTECTED]> wrote: Saya bikin Aplikasi Di win 2003 dan memakai > smartnetbutton.ocx... > > kenapa pas di Win XP error ya... yang ada tombol "Send > Error" dan "Dont Send > Error" > > tapi pas smartnetbuttonnya di ganti dengan bawaan > standar VB6...jadi ok ok > aja.. > > pertanyaan saya : > Apa bener yang namanya OCX third Party itu g stabil..? > > ----- Original Message ----- > From: "Ronald Irawan" <[EMAIL PROTECTED]> > To: <[email protected]> > Sent: Thursday, June 15, 2006 11:50 AM > Subject: RE: [Programmer-VB] Tanya Select Distinct > > > Jam jgn dibawa lagi > > Select Kode, Rinician, User, Tgl, sum(jam) as hour > FROM DETAIL group by > > Kode, Rinician,User, Tgl > > > > Salam > > Ronald Irawan > > Pt. Sanghiang Perkasa > > Gd. Graha Kirana Lt.5 > > Jl Yos Sudarso Kav.88 > > Jakarta > > > > > > > > De ce <[EMAIL PROTECTED]> > > Sent by: [email protected] > > 15/06/2006 11:42 AM > > Please respond to > > [email protected] > > > > > > To > > [email protected] > > cc > > > > Subject > > RE: [Programmer-VB] Tanya Select Distinct > > > > > > > > > > > > > > Mas-Mas sekalian, > > > > Saya sudah rubah field JAM menjadi NUMBER dan saya > run dengan query: > > > > Select Kode, Rinician, User, Tgl, Jam, sum(jam) as > hour FROM DETAIL group > > by Kode, Rinician,User, Tgl, Jam order by User, Tgl > > > > Tapi hasilnya tetap satu-satu ya (hasil saya > attach). > > > > USER TGL KODE RINICIAN JAM > > DC 16/01/2006 7005008 OTHER DEVELOPMENT > 1 > > DC 16/01/2006 7005008 OTHER DEVELOPMENT > 3 > > DC 16/01/2006 7005008 OTHER DEVELOPMENT > 4 > > DC 17/01/2006 8005003 MAINTENANCE > 1 > > DC 17/01/2006 8005003 MAINTENANCE > 4 > > > > Yang di harapkan hasilnya: > > > > USER TGL KODE RINICIAN JAM > > DC 16/01/2006 7005008 OTHER DEVELOPMENT > 7 > > DC 17/01/2006 8005003 MAINTENANCE > 5 > > > > Mohon bantuannya, terima kasih. > > > > > > > > "Nfs, Ibrahim" <[EMAIL PROTECTED]> wrote: > > Dear De Ce, > > > > Kalau begitu diconvert aja mas data jamnya, baru di > sum. > > Select Kode, Rinician, User, Tgl, sum(cast(Jam as > int)) as hour FROM > > DETAIL group by Kode, Rinician, User, Tgl > > Atau > > Select Kode, Rinician, User, Tgl, sum(A.hour) FROM > > FROM > > (Select Kode, Rinician, User, Tgl, cast(Jam as int) > as hour FROM DETAIL) A > > GROUP BY > > A.Kode, A.Rinician, A.User, A.Tgl > > > > Mudah-mudahan bisa membantu. > > > > Regards, > > > > Ibrahim > > mailto:[EMAIL PROTECTED] > > > > > > From: [email protected] > [mailto:[EMAIL PROTECTED] > > On Behalf Of De ce > > Sent: Thursday, June 15, 2006 9:18 AM > > To: [email protected] > > Subject: Re: [Programmer-VB] Tanya Select Distinct > > > > Mas-mas sekalian, > > > > Saya sudah coba dengan: > > > > Select Kode, Rinician, User, Tgl, sum(Jam) as hour > FROM DETAIL group by > > Kode, Rinician, User, Tgl > > > > Tapi keluar error 3464 - Data type mismatch in > criteria expression > > > > Untuk informasi saja field JAM itu bukan number tapi > text apa harus saya > > rubah ke number ya? (maaf ini tabel warisan) > > > > Trims. > > > > tahar dn <[EMAIL PROTECTED]> wrote: > > Kayaknya nya begini sintak sqlnya : > > > > "select code,act,user,date,sum(hour) hour from ..... > group by > > code,act,user,date > > mudah-mudahan bisa > > > > > > De ce <[EMAIL PROTECTED]> wrote: > > Rekan mau tanya nih, > > > > Code Act User > Date Hour > > 0001 Administrasi Budi > 14/06/2006 1 > > 0002 Marketing Budi > 14/06/2006 4 > > 0003 Meeting Budi > 14/06/2006 1 > > 0001 Administrasi Budi > 14/06/2006 1 > > > > Data di atas kode 0001 terdapat 2 transaksi dan yang > ingin saya tanyakan > > bagaimana command untuk bisa search sekalian filter > dengan tampilan sbb: > > > > Code Act User Date > Hour > > 0001 Administrasi Budi 14/06/2006 > 2 > > 0002 Marketing Budi 14/06/2006 > 4 > > 0003 Meeting Budi 14/06/2006 > 1 > > > > Kalau saya menggunakan query select distinct code > ... maka penjumlahan > > jamnya tidak ada. Mohon bantuannya. > > Terima kasih > > > > ME > > __________________________________________________ > > Do You Yahoo!? > > Tired of spam? Yahoo! Mail has the best spam > protection around > > http://mail.yahoo.com > > > > __________________________________________________ > > Do You Yahoo!? > > Tired of spam? Yahoo! Mail has the best spam > protection around > > http://mail.yahoo.com > > > > __________________________________________________ > > Do You Yahoo!? > > Tired of spam? Yahoo! Mail has the best spam > protection around > > http://mail.yahoo.com > > > > __________________________________________________ > > Do You Yahoo!? > > Tired of spam? Yahoo! Mail has the best spam > protection around > > http://mail.yahoo.com > > > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com > > > > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ------------------------ Yahoo! Groups Sponsor --------------------~--> Yahoo! Groups gets a make over. See the new email design. http://us.click.yahoo.com/XISQkA/lOaOAA/yQLSAA/k7folB/TM --------------------------------------------------------------------~-> Wahana Programmer Groups Links <*> Untuk mengunjungi sponsor milis ini, klik link berikut: http://wahanaprogrammer.net <*> Untuk menghubungi owner milis ini, kirim email ke: [EMAIL PROTECTED] <*> Konsultasi pemrogramman bisa chat disini: Yahoo! Messenger: wahanaprogrammer Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/Programmer-VB/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
