in my Database I have a process that creates dues for members once a year. What I would like to do is when I run the process to create the dues it would first create a copy of the DUEST table just in case something goes wrong.
Kevin Robertson 8 days ago
The code below will first DELETE the backup table, then create a backup copy of the table.
On Error Resume Next
CurrentDb.Execute "DROP TABLE [DuesT - BACKUP]"
DoCmd.CopyObject CurrentDb.Name, "DuesT - BACKUP", acTable, "DuesT"
Note: Remember to make a manual backup first BEFORE running the above code (just in case).
Jerry Fowler 8 days ago
Thanks. I was thinking something along this line or like when you copy a table using Ctrl C then Paste using Ctrl V but using VBA
Maggie M 6 days ago
See Access Expert 16, Lesson 3, 7:40
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.