How do I turn off Warning Message" in Macro design

[newtoAccess]

I am in the Macro design.

I have set the following
open a table.
show all records
select all records


delete record
Close and save table

The above works good.
However it gives me a "Warning that I am about to delete 243 records".

Question: How and where do I turn off the warning?

[ssanfu]

The best way would be to use VBA. In VBA, you would use

Currentdb.Execute "DELETE * FROM YourTableName", dbFailOnError

If you must use a macro, there is an action "SetWarnings".

show all records
select all records
SetWarnings --- NO << turns OFF warnings
delete record
SetWarnings --- YES << turns ON warnings
Close and save table

[newtoAccess]

Ya, I am not very good at VBA or sql so I use as much automated stuff as possible. I don't understand when to use VBA or when to use SQL.

[newtoAccess]

Thanks
that worked