Update Query is not Working / Updateting

  • Thread starter Carlos Garcia via AccessMonster.com
  • Start date
C

Carlos Garcia via AccessMonster.com

Hello,

I need some help with the query below. It is not update the table with the
value 'Carlos'. I read another comment about this regards here and I have
included the Temp, but It did not work for me. Thank you in advance for
your help. Thanks.

strSQLNova = "UPDATE " & TableUpdate & ", Temp" _
& " SET " & TableUpdate & "." & TableField _
& " = 'Carlos' ;"
'oDB.Execute strSQLNova
 
C

Carlos Garcia via AccessMonster.com

Hi Guys,

I just found the solution. Thanks.

strSQLNova = "UPDATE " & TableUpdate & " SET " & TableUpdate & "." &
TableField & " = '" & ValueX & "' ;"
oDB.Execute strSQLNova
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problems with RIGHT JOIN and VBS 4
Must use updatetable query - work around 5
left join query is not working 5
Query Quandry 6
Copy records without dupliacates 1
Update Progress Information and Reschedule work for all Tasks - Project 2003 0
Drop down list control value in vba 2
Update access table to sql table 1

Top