"UPDATE" SQL Statement

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Fred - 18 Jul 2005 23:03 GMT

....I've been trying to make this UPDATE sql statement work:

sqlSTRING = "UPDATE tblCLIENTS SET tblCLIENTS.CL_ID = '" _
& Me.txtNEW & "' WHERE ((tlbCLIENTS.CL_ID) = '" _
& Me.txtORIGINAL & "');"

I always get a VB "...Run-time error '3219'...Invalid Operation..." error
message. What am I doing wrong.

Reply to this Message

Van T. Dinh - 18 Jul 2005 23:33 GMT

SQL construction looks OK but I normally use:

sqlSTRING = "UPDATE tblCLIENTS SET tblCLIENTS.CL_ID = '" & _
Me.txtNEW & "' WHERE ((tlbCLIENTS.CL_ID) = '" & _
Me.txtORIGINAL & "');"

Post the relevant VBA code (around the SQL construction) and mark which line
of code errors out. I don't think the problem is in the SQL construction
unless you have spelloing error in Table / Field names.

Signature

HTH
Van T. Dinh
MVP (Access)

> ....I've been trying to make this UPDATE sql statement work:
>
[quoted text clipped - 4 lines]
> I always get a VB "...Run-time error '3219'...Invalid Operation..." error
> message. What am I doing wrong.

Reply to this Message

Chaim - 19 Jul 2005 15:56 GMT

Speaking of spelling mistakes, is that 'tlbCLIENTS' in the where clause
supposed to be 'tblCLIENTS'?

Signature

Chaim

> SQL construction looks OK but I normally use:
>
[quoted text clipped - 14 lines]
> > I always get a VB "...Run-time error '3219'...Invalid Operation..." error
> > message. What am I doing wrong.

Reply to this Message