Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jul 2001
    Posts
    280
    Thanks
    0
    Thanked 0 Times in 0 Posts

    delete all records in a table (Access 2000)

    I want to delete all the records in the table CurrentProducts in the OnClose event of a form which is not tied up with this table.
    How can i accomplish this?

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: delete all records in a table (Access 2000)

    You could use
    CurrentDb.Execute "DELETE * FROM CurrentProducts"
    Francois

Posting Permissions

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