I have a legacy database in Access that we upgraded in the new Office 2013. In there is a form that runs a macro to open a specific table, select all records, delete them and close the table. Then it runs an append query to add in new records. It uses sendkey to select all records and delete. This is no longer working. I created a delete query to replace the table steps and tried to open query - datasheet view - edit like the append query. That doesn't work either. So far every time I run the macro either using the sendkeys for the table or delete query it seems to ignore it and just append new records into the table. Any ideas?
Thanks!
Thanks!