Rookie trying a Delete tables Module

[ODBCERRORKING]

Hello,
i am looking to delete certain tables out of my database for the next run time.the tables that have to be deleted out of the database are IBMLOTUS_CEO_TEMP,IBM_CO_TEMP etc.. i would like to write some sort of code or process and put it behind a button in a form. where is the code written is there a code builder in access or will i need to know vb.

 

[Databaseguy]

Two ways:

1. Use a macro. Not recomended, but it works. Choose Macros/New/Delete Object, Object Type Table, choose trhe name.

2. Save the above macro using Save As from the File menu. Choose the Save as VB Code option button. Call the code created from a button or whatever you want to use to start the event. (Cheap way for beginners to learn code)