Updating access table
Now run the qry Update Album Prices query found in the same database (see Figure 1-17).This action query will take the Purchase Price values from tbl Albums Updated and copy it into the Purchase Price field in tbl Albums for each record where the two Album ID fields match and the price value in tbl Albums is currently null.
You can do it with Combo Box or List Box, as both Properties in Lookup tab are extremely similar (both allow multiple selection). Qty_mt) AS Sum Of Qty_mt FROM Orders INNER JOIN Order Detail ON Orders. Open Recordset(sql, db Open Dynaset) With rst Do Until rst. Order Detail Status = "Allokeer" Then sql = "UPDATE [Inventory CT] SET [Stock Allocated] = " & ! The data in all the other fields in the existing table is still correct.Is there any way—short of using a complex VBA procedure—to update the price data in the existing table based on the updated prices from the imported table without overwriting any of the other fields in the existing table?
Execute (sql) Else sql = "UPDATE [Inventory CT] SET [Stock Opgelaai] = " & !