Macro to delete records in a table...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a macro that emptys a table, before repopulating the table with append
queries. What is the best way to have a macro empty a table?

Currently I am using the sendkeys command to select all records and then
delete. This works, however there are problems with this when the user
changes active windows while the macro is running.
 
Create a delete query that will delete the records in that table. Save it.

Then use OpenQuery action in macro to run that query.

If you want to avoid the "warning: you're about to delete....." message,
precede the OpenQuery action with SetWarnings action (set the argument to
No).
 

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

Similar Threads

Compact & Repair, Open table, close table, then run macro 3
macro for deleting records 2
How to count table records in a macro 1
pausing a macro 1
Need to refresh the table 1
Access Automatically Send a notification email once a record is added 0
Cancel Macro If Table is empty. 5
Access Macro Repeat Expression using value of a field in table 0

Back
Top