Delete all records from table

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • BurtonBach
    New Member
    • Oct 2006
    • 58

    #1

    Delete all records from table

    I have a table that is intended to hold data temporarily. Is it possible to make a command button (or something similar) that will delete all the records in this table once the user is done with the data?
  • MMcCarthy
    Recognized Expert MVP
    • Aug 2006
    • 14387

    #2
    Originally posted by BurtonBach
    I have a table that is intended to hold data temporarily. Is it possible to make a command button (or something similar) that will delete all the records in this table once the user is done with the data?
    Just put this code behind the command button.

    Code:
    DoCmd.RunSQL "DELETE * FROM Tablename;"
    Mary

    Comment

    Working...