Delete all Rows in a table then append new rows to same table by automatically every 5 minutes.
Posted on 2016-10-18
Thank you all in advance.
I have a form which in turn has one button. That button launches a macro. The macro launches one Delete query and subsequently an append query. I would like to have the Macro that cycles the data (the macro that deletes an then appends) run every 5 minutes.
What would be the easiest way to make this happen given the MS ACCESS elements I've mentioned above?
It looks like vba code is the best way to make this happen, but Im at best a beginner at vba so please, feel free to provide some explanation around any vba code provided.
Thank you again!