again update problem

  • Thread starter Thread starter Art Vandaley
  • Start date Start date
A

Art Vandaley

Hi,

I want to update data of an external table. I need to write VBA code with
UPDATE Statement but I don't know using IN Clause together with UPDATE. Can
you please write down a sample code in order to have an idea about correct
syntax. Best Regards.
 
UPDATE Table1 SET Data1 =1, Data2 ='Data 2'
WHERE RecID In (select recid from query2)
 
UPDATE tblTest IN "D:\AccessTests\A2K2_MyTest\Test02.mdb"
SET Pole1 = 10
WHERE Pole1 = 1


tblTest is in the "external" JET database Test02.mdb.
 
You must log in or register to reply here.

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

Windows Update 0
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
SQL syntax help please 6
How to subtract a number from a Mergefield? 0
Refresh DataRecordset display on Subform Datasheet 1
How to refer to a VBA module variable within a report select state 3
Access MS Access vba AfterUpdate coding question (hopefully a simple fix!) 0
update problem 1

Back
Top