Search results

Sorry, that wasn't meant to be detailed instructions, just meant to be a guideline, I didn't take the time to explicitly define all the tables queries and code. What you're missing are all the blanks I didn't fill in. The point was to give an idea of a method that will allow you to delete the...

One way to do it would be as follows: 1. create a delete query to delete all the records in the table 2. Create a table to keep a log of deletion dates 3. before executing the delete query, save the current date in the log table 4. don't execute the query unless the date of the last delete...

DoCmd.RunCommand acCmdSaveRecord