Member Avatar for Smart System

What is wrong in this code ?

rs.Open " update TblName set FldNum=" & text1.Text & " where ID_FldName=" & Text2.Text , db, adOpenDynamic, adLockOptimistic

Knowing that
FldNum ---> Data type (Number)
ID_FldName ---> Data Type (AutoNumber)

And What the correct code ?

  • 3 Contributors
  • 3 Replies
  • 78 Views
  • 16 Hours Discussion Span
  • Latest Post Latest Post by vb5prgrmr
Member Avatar for vb5prgrmr

Looks like you have it... Only need to add single ticks around strings and since both of your fields are numeric, I think you have it...

Good Luck

Member Avatar for kinwang2009

Try using

rs.Open "update TblName set FldNum = '" & Text1.Text & "' where ID_FldName = '" & Text2.Text & "'", db, adOpenDynamic, adLockOptimistic

Hope this helps

Member Avatar for vb5prgrmr

Kin, please reread this thread...

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.