ACC2000: How to Delete Objects Programmatically (209032)
The information in this article applies to:
This article was previously published under Q209032 Moderate: Requires basic macro, coding, and interoperability skills.
SUMMARY
You can delete objects programmatically by using either the Delete method or the DeleteObject method. You can also use the DeleteObject action in macros.
MORE INFORMATION
The Delete method applies to the QueryDefs and TableDefs collections and can be used to delete queries and tables. The Delete method does not apply to the Containers collection and cannot be used to delete objects such as forms or reports.
You can use the DeleteObject method (in code) or action (in a macro) to delete objects that you cannot delete by using the Delete method. Note that Microsoft Access does not request user confirmation when you delete objects by using either the Delete method or the DeleteObject method or action.
REFERENCESFor more information about the Delete method, in the Visual Basic Editor, click Microsoft Visual Basic Help on the Help menu, type Delete method in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
For more information about the DeleteObject method, in the Visual Basic Editor, click Microsoft Visual Basic Help on the Help menu, type DeleteObject method in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
| Modification Type: | Minor | Last Reviewed: | 10/11/2006 |
|---|
| Keywords: | kbdta kbhowto kbProgramming KB209032 |
|---|
|