coma setelah perintah set (sebelum perintah where..) menyebabkan error semoga membantu
--- Frangky <[EMAIL PROTECTED]> wrote: > Teman-teman Pakar VB yang terhormat! > > Saya menggunakan kode dibawah ini untuk meng-update > Nilai Setroran Airlines, tapi error, mungkin > sintaxnya salah. > > Mohon koreksi dari teman-teman. > > > Private Sub cmdUpdate_Click() > > cnn.Execute "update Table1 SET " & _ > " SETORANAIRLINES = '" & txtSetAirlines & "', " & _ > " WHERE PESAWAT = '" & cboPesawat & "' and RUTE1= '" > & txtDari & "' and RUTE2= '" & txtTujuan & "' AND > CLASS= '" & txtKelas & "'" > > End Sub > > > > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ------------------------ Yahoo! Groups Sponsor --------------------~--> Check out the new improvements in Yahoo! Groups email. http://us.click.yahoo.com/6pRQfA/fOaOAA/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/
