Access Update Query Not Working[Answered] RSS

• • Reply
  codinghelppl...

  None

  0 Points

  13 Posts

  Access Update Query Not Working

  Jan 16, 2014 02:08 PM|codinghelpplz|LINK

  The error I get is that Syntax Error (missing operator) in query expression '[TblSupplier.ID] =' 

  plz help

• • Reply
  hans_v

  All-Star

  25756 Points

  7014 Posts

  Re: Access Update Query Not Working

  Jan 16, 2014 07:10 PM|hans_v|LINK

  These forums are intended for ASP.NET (web) related questions only!

• • Reply
  wmec

  Contributor

  6479 Points

  5815 Posts

  Re: Access Update Query Not Working

  Jan 18, 2014 03:18 AM|wmec|LINK

  codinghelpplz

  The error I get is that Syntax Error (missing operator) in query expression '[TblSupplier.ID] =' 

  plz help

  Show your full codes please.

  Many Thanks & Best Regards,
  Peter
  
• • Reply
  TUFAN01MAN

  Participant

  770 Points

  314 Posts

  Re: Access Update Query Not Working

  Jan 21, 2014 07:58 AM|TUFAN01MAN|LINK

  You  must have forgotten somewhere ( ' ) sign in your commandText

  for example "select * from Customers where CustName= ' " & TextName.Text & " ' "

  you may forgotten last " ' " sign.

   

  TUFAN01MAN