Re: [Programmer-VB] Help - Sintax SQL Error ---Solved

[Dedy]

oh ya benar..thanx bung Fountain ----- Original Message ----- From: Fountain Melody To: Programmer-VB@yahoogroups.com Sent: Wednesday, July 06, 2005 12:42 PM Subject: Re: [Programmer-VB] Help - Sintax SQL Error mungkin tanda petik satu disebelah kanan # itu nggak usah, jadi seperti ini: rs.Open "select * from pinjaman where PeriodeAkhir=#" & cboPeriode.Value & "# and status='A'", dbkoperasi   semoga membantu ----- Original Message ----- From: Dedy To: Programmer-VB@yahoogroups.com Sent: Wednesday, July 06, 2005 11:57 AM Subject: [Programmer-VB] Help - Sintax SQL Error guys.. dimana letak kesalahan sintax sql dibawah ini, mohon bantuannya..   Dim rs As New Recordset rs.Open "select * from pinjaman where PeriodeAkhir=#" & cboPeriode.Value & "#' and status='A'", dbkoperasi   error message "Sintax error(missing operator)in query _expression_"   thanx, Untuk keluar dari millis ini, kirim email kosong ke: [EMAIL PROTECTED] 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.