Need a macro to delete ALL records in a table...

  • Thread starter Thread starter Lynn Pennington
  • Start date Start date
L

Lynn Pennington

Hello.
Any Ideas on how to create a macro to delete ALL records
in a table???
Thanks.
Lynn.
 
Hi,
You can create a delete query for the table, and run
that from a macro.
 
Thanks.
Does Access have a command window where you can just type
commands?
Lynn.
 
Les, when the macro runs, I still have to click yes twice. Is there a way to include that in the macro
(Thanks Lynne for asking my question.)
 
Try adding a new command into your macro - right at the
top. Select the setwarnings action and set Warnings On to
NO.
-----Original Message-----
Les, when the macro runs, I still have to click yes
Click to expand...
twice. Is there a way to include that in the macro?
 
In the macro, run a SQLstatement .. Delete * from
(tablename). That will do it
 
You must log in or register to reply here.

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

How to count table records in a macro 1
Deleting all values of a field 3
macro for deleting records 2
Access Automatically Send a notification email once a record is added 0
Delete error table using IF in macro 2
Delete Objects Errors 4
Record Macros in Access 2003? 1
Need to refresh the table 1

Back
Top