'' Access VBA methods to delete ms access object
'************** Delete your table or query
DoCmd.RunSQL "Drop table yourTableName or yourQueryName"
CurrentDb.Execute "Drop table yourTableName or yourQueryName"
'*** Below method will allow to delete any of the access objects (Table, Query, Form, Report) *****
DoCmd.DeleteObject acQuery, "YourQueryName"
'Select any of the below access object types that you want to delete
'acTable
'acQuery
'acForm
'acReport
'************** Delete your table or query
DoCmd.RunSQL "Drop table yourTableName or yourQueryName"
CurrentDb.Execute "Drop table yourTableName or yourQueryName"
'*** Below method will allow to delete any of the access objects (Table, Query, Form, Report) *****
DoCmd.DeleteObject acQuery, "YourQueryName"
'Select any of the below access object types that you want to delete
'acTable
'acQuery
'acForm
'acReport
Excellent and very exciting site. Love to watch. Keep Rocking.
ReplyDeleteexcel vba courses london