Hi,
Have really been struggling with this and have spent many, many hours (and much coffee) trying to find a solution on the internet. I have an Access database with a table that stores budget data. I use Excel to visualize the budget data and for entering budget items. I have about 25 users. I have code that works great for updating and adding new records to the Access table from Excel. My issue is deleting records from the Access table if a user deletes a budget item in the Excel table. Both the Excel table and the Access table have a unique field called "Item ID". Both the Excel and Access tables have a field called "Project Code". There are 42 different project codes representing 42 different programs.
Goal - In the Access table, I need to find the Item IDs for a project code that no longer exist is the Excel budget table for the program. Once found, I need to delete the Item ID row from the Access table.
I had to attach the code for updating and adding records in the Access table because I was blocked from putting it in this post.
Greatly appreciate assistance with figuring this out.
Karen
Bookmarks