 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / June 2004Delete Records with Code
Hello, Does anyone know how I can delete all records from a table using code, while not harming the table format? Thank you, MaryF A Delete query will do this. Add the table to the query builder then select Query | Delete query from the menu. The SQL will look like: DELETE FROM TableName  SignatureDoug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) > Hello, > Does anyone know how I can delete all records from a table using code, while not harming the table format? > Thank you, MaryF DoCmd.RunSQL "DELETE * FROM tempOpen;" Marc > Hello, > Does anyone know how I can delete all records from a table using code, while not harming the table format? > Thank you, MaryF Thank you Mark and Doug!!! It worked perfectly!! :) Mary > DoCmd.RunSQL "DELETE * FROM tempOpen;" > [quoted text clipped - 4 lines] > while not harming the table format? > > Thank you, MaryF You can create a delete query. Add the table to the query, set the field entry to * rather than individual fields and keep the criteria section empty. This will delete ALL the data and not the structure of the table. Note: This is permanent and can not be undone, so you must make sure this is what you really want to do. The query once created can be connected to a command button which can be executed upon clicking if you need this on a continual basis, such as removing the content from a temporary table in order to add new records to be processed. SignatureG Vaught > Hello, > Does anyone know how I can delete all records from a table using code, while not harming the table format? > Thank you, MaryF Thank you too, GVaught, for your helpful reply. I really appreciate all of the assistance I received. :0) Mary > You can create a delete query. Add the table to the query, set the field > entry to * rather than individual fields and keep the criteria section [quoted text clipped - 11 lines] > while not harming the table format? > > Thank you, MaryF |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.