delete records macro

[George Walters]

I wan to start a macro by opening a table and deleting all the records

 

[Steve Schapel]

George,

Opening the table is not necessary, in order to do this. Just make a
Delete Query to delete all records from the table, and then use an
OpenQuery action in your macro to run the delete query.

Once you have it working correctly, you might also want to put a
SetWarnings/No action in the macro before the OpenQuery action, to
suppress the display of the action query confirmation message.

 

[George Walters]

Easy!@Thanks

George,

Opening the table is not necessary, in order to do this. Just make a
Delete Query to delete all records from the table, and then use an
OpenQuery action in your macro to run the delete query.

Once you have it working correctly, you might also want to put a
SetWarnings/No action in the macro before the OpenQuery action, to
suppress the display of the action query confirmation message.