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

[Lynn Pennington]

Hello.
Any Ideas on how to create a macro to delete ALL records
in a table???
Thanks.
Lynn.

 

[Les]

Hi,
You can create a delete query for the table, and run
that from a macro.

 

[Lynn Pennington]

Thanks.
Does Access have a command window where you can just type
commands?
Lynn.

 

[Amanda]

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.)

 

[Les]

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

twice. Is there a way to include that in the macro?

 

[Amanda]

Thank you!

 

[Al V]

In the macro, run a SQLstatement .. Delete * from
(tablename). That will do it