Hey,
Apologies in advance; I am new to using Access. I've written Excel macros etc but am now learning my way through Access.
Anyhow, I wrote a module that when executed updates and SQL table from an access database. It deleted the data in the SQL table and then uploads the data from the access table.
What I now want to do is almost the reverse. I have a table in SQL that list any changes that have been made to specific rows (namely moving the status from query to approved, and in this table there is also a column with the corresponding access ID for the record. What I now want to create is a module that I can run in access that finds records that are in this SQL table, and updates the status column to match the status in the SQL table.
So for example.
This would be my Access table:
Access ID Status 1 Query 2 Query 3 Query 4 Query 5 Query 6 Query 7 Query 8 Query
This is the SQL table:
SQL ID Access ID Status 1 3 Approved 2 7 Approved
So I would want to write a module that updates records 3 and 7 in access to have a status of Approved.
I hope that makes sense?
Thanks!