Can RunCommand Backup in a Macro without closing all objects?

P

paulpenta

I have a table called Perf_table. It is updated manually from another "temp"
table using an Append query. This allows the table bound to the data entry
form to be empty at the beginning of each session.

The records appended are then QC'd. Once they pass this level, they are
appended to another final table for review by the decision makers. After this
last append, I clear out the appended records with a delete query which uses
the checkbox used by the QC person to indicate approval as the creterion for
which records get deleted.

I delete them so that subsequent "appends" to the final table don't get
duplicate records. Is there any way to RunCommand Backup before the delete
query so i can keep "safety" copies of all records?

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top