Re: Syntax error in Form

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

<Sangee@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

> Hi,
>
> I have a form call Job Card.
>
> When I open the form and enter the values and click the add button, it
> gets added(only for the first time the form is opened).
>
> When I enter the values again without exiting the form, it is giving
> me an error "Syntax error in INSERT INTO statement". Whereas, when I
> exit the form and enter the values, it gets inserted without any
> error.
>
> So each and every time I insert a record I need to close the form and
> open it again.
>
> Can anyone help me how to solve this issue.
>
> Thanks.
>
> When i enter the values for the first time it is
> opened, and click the ADD button it gets inserted into the table but
> when i enter the values again it is giving me "Syntax error in INSERT
> INTO statement". Whereas when i exit the form and open again it gets
> inserted. So, every time i add the record, i need to exit and open the
> form again to insert another record. Can anyone help me with this
> issue?
>
> Thanks.

Hi Sangee,

It would help everyone here if you would paste your ADD_Click() code in a
post so we can see what you are trying to do.

--
RuralGuy

Please reply to the newsgroup so all may benefit.
.

Relevant Pages

  • Syntax error in Form
    ... I have a form call Job Card. ... added(only for the first time the form is opened). ... enter the values again it is giving me "Syntax error in INSERT INTO ... Whereas when i exit the form and open again it gets inserted. ...
    (microsoft.public.access.formscoding)
  • Form needs to be closed everytime
    ... I have a form in which when i enter the values for the first time it is ... enter the values again it is giving me "Syntax error in INSERT INTO ... Whereas when i exit the form and open again it gets inserted. ... Prev by Date: ...
    (microsoft.public.access.forms)
  • Re: Syntax error in Form
    ... Private Sub cmdAdd_Click ... Exit Sub ... "RuralGuy" wrote: ... >> gets added(only for the first time the form is opened). ...
    (microsoft.public.access.formscoding)
  • Re: Exiting from python shell
    ... remember a time that I typed the ^D the first time. ... been so awful to just let it be a way to exit when the shell? ... to exit python via a keyword would require also reformulating mathematics as we know it. ...
    (comp.lang.python)
  • Re: Exiting from python shell
    ... remember a time that I typed the ^D the first time. ... been so awful to just let it be a way to exit when the shell? ... to exit python via a keyword would require also reformulating mathematics as we know it. ...
    (comp.lang.python)