Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2003
    Posts
    14

    Unanswered: Erase records Macro

    Hi,

    Does anybody know how how to write a macro in Access to open a table and erase all records in that table?

    Thank you very much.

  2. #2
    Join Date
    Oct 2001
    Location
    Chicago
    Posts
    440
    Create a RunSQL macro and use "DELETE * FROM TableName" as the SQL Statement.

    Matt

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •