Recent content by mjancic

  1. M

    RUN TIME ERROR 3144, syntax error in update statement

    Finnaly, I found out what was the cause :))) I use "," as decimal separator. When I change "," into "." it works. Thanks for your help. Cheers Milan
  2. M

    RUN TIME ERROR 3144, syntax error in update statement

    Hi, Thanks for your advice, but sorry I'm do not know how to run deboug.print strSQL. Where do i need to put it, into now module into my user from or??? Below you can find complete code of my user from, maybe it can help you to define where the problem is. Thanks Milan Option...
  3. M

    RUN TIME ERROR 3144, syntax error in update statement

    Hi, Field size property is set up as DOUBLE and it won't work. Can I change anything else to get this thing working? FYI, I'm not skilled in writting scripts, I just recieved this file from my colleague, but we cannot figure out why it is not working in access 2007, but it is working in...
  4. M

    RUN TIME ERROR 3144, syntax error in update statement

    It won't work. When I go to DEBUG, marked is DoCmd.RunSQL strSQL
  5. M

    RUN TIME ERROR 3144, syntax error in update statement

    Hi, ideal_px field is a number data type
  6. M

    RUN TIME ERROR 3144, syntax error in update statement

    Hi, I have a problem with one script. This scrip is working in access 2003, but it wont work in access 2007. When I run it in 2007 I get run time error 3144, syntax error in update statement. Please take a look at this script below. Private Sub cmd_update_Enter() Dim ideal_px As Double Dim...
Top Bottom