L
Lynn Pennington
Hello.
Any Ideas on how to create a macro to delete ALL records
in a table???
Thanks.
Lynn.
Any Ideas on how to create a macro to delete ALL records
in a table???
Thanks.
Lynn.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
L
Les
Hi,
You can create a delete query for the table, and run
that from a macro.
You can create a delete query for the table, and run
that from a macro.
L
Lynn Pennington
Thanks.
Does Access have a command window where you can just type
commands?
Lynn.
Does Access have a command window where you can just type
commands?
Lynn.
G
Guest
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.)
(Thanks Lynne for asking my question.)
L
Les
Try adding a new command into your macro - right at the
top. Select the setwarnings action and set Warnings On to
NO.
top. Select the setwarnings action and set Warnings On to
NO.
twice. Is there a way to include that in the macro?-----Original Message-----
Les, when the macro runs, I still have to click yes
G
Guest
Thank you!
A
Al V
In the macro, run a SQLstatement .. Delete * from
(tablename). That will do it
(tablename). That will do it