delete records macro

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
Easy!@Thanks

Steve Schapel said:
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.
 
Back
Top