tambahin spasi sebelum kata "values" cobain deh... -- regards,
Rizky Prihanto http://www.software-arsitek.web.id On 3/2/08, gunawan gofur <[EMAIL PROTECTED]> wrote: > > Dear Friends, > Saya punya command : > Private Sub cmdSave_Click() > aSQL = "insert into Applicant(FirstName, Primary, Secondary)values" > aSQL = aSQL + "(' " & txtname.text & " ',' " & chkprimary.value & " ',' > " & chksecondary.value & " ')" > MsgBox "save", , "information" > End Sub > tapi command itu error terus pas d klik selalu muncul "syntax errror in > INSERT INTO STATEMENT", saya memakai access, dengan fieldname > FirstName(text) , primary dan Secondary (yes/no) dengan > txtname.text(Textbox), > chkprimary dan chksecondary(Checkbox). > Mohon Pencerahannya, dan bantuan dari teman2 > regards > > > > [Non-text portions of this message have been removed]
