[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Delete a table in Access

Posted on 2011-02-21
2
Medium Priority
?
319 Views
Last Modified: 2012-05-11
Is there a way to click a button that will run an querry that will delete a table in access? If so, what is the coding of the querry?

Thanks!
0
Comment
Question by:cansevin
  • 2
2 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 2000 total points
ID: 34943375
place this code in the click event of the button

currentdb.execute "drop table tableX"

change tableX with the name of table you want to delete
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 34943385
to delete "records" from a table

currentdb.execute "delete * from TableX"
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
Beware when using the ListIndex and the Column() properties of a listbox in Access 2007.  A bug has been identified in the Access 2007 listbox code which can cause the .ListIndex property to return a -1, and the .Columns(#) property to return a NULL…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

608 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question