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

Recommended Answers

All 3 Replies

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.