Go Back   Access World Forums > Microsoft Access Discussion > Macros

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 10-03-2017, 05:55 AM   #1
AC5FF
Newly Registered User
 
AC5FF's Avatar
 
Join Date: Apr 2004
Location: Rapid City SD
Posts: 538
Thanks: 10
Thanked 1 Time in 1 Post
AC5FF is on a distinguished road
DeleteObject not found?

According to Microsoft (probably my first error in trusting them) DeleteObject is still available in Access2016. I'm not sure why, but I'm not seeing it or I can't even type it in.

Honestly I ran into the same problem when I was using the ImportExport Text command in the macro. Only reason I got that to work was by copying it out of a pre-existing macro.

Is it possible I do not have something installed correctly - maybe missing some add-on from when Office was installed?

All I'm looking to do is delete an ImportErrors table.

Now I know that this can be a fairly simple task in VB - but I'm no VB expert; not even a nOOb at it. I'd just prefer to stick with the macro option at this time.

TIA

__________________
If flying were the language of men than soaring would be his poetry.

Last edited by AC5FF; 10-03-2017 at 05:56 AM. Reason: Forgot to add link
AC5FF is offline   Reply With Quote
Old 10-03-2017, 06:51 AM   #2
RogerCooper
Newly Registered User
 
Join Date: Jul 2014
Posts: 75
Thanks: 0
Thanked 8 Times in 7 Posts
RogerCooper is on a distinguished road
Re: DeleteObject not found?

Did you click "Show All Actions" on the "Design" tab?
RogerCooper is offline   Reply With Quote
Old 10-03-2017, 06:58 AM   #3
arnelgp
Newly Registered User
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 4,430
Thanks: 47
Thanked 1,479 Times in 1,407 Posts
arnelgp has a spectacular aura about arnelgp has a spectacular aura about arnelgp has a spectacular aura about
Re: DeleteObject not found?

Yup, just check on
my A2016 x64, its there alright.

you an use SQL query to delete the table:

DoCmd.RunSQL "Drop Table tableName;"

__________________
"Never stop learning, because life never stops teaching"
arnelgp is online now   Reply With Quote
Old 10-03-2017, 07:10 AM   #4
AC5FF
Newly Registered User
 
AC5FF's Avatar
 
Join Date: Apr 2004
Location: Rapid City SD
Posts: 538
Thanks: 10
Thanked 1 Time in 1 Post
AC5FF is on a distinguished road
Re: DeleteObject not found?

Quote:
Originally Posted by arnelgp View Post
DoCmd.RunSQL "Drop Table tableName;"
I may try this!?! The tablename is OutFileReport_ImportErrors
So would this be DoCmd.RunSQL "Drop Table OutFileReportImportErrors"
Including quotes?

And I was sure I clicked on 'Show All Actions' but I re-opened the dbase and clicked it again and now DeleteObject is showing!

I need a new computer! LOL

Thanks all!

__________________
If flying were the language of men than soaring would be his poetry.
AC5FF is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
deleteobject acform problem pedrocat Forms 7 11-08-2011 08:27 AM
DeleteObject not working. Extra_Cover Macros 4 11-05-2008 10:55 PM
Macro Deleteobject trouble ukmale65000 General 3 12-16-2007 01:19 AM
[SOLVED] DeleteObject A_MODULE in Access 2.0 johnbrewster Modules & VBA 0 02-05-2003 03:43 AM
Docmd.DeleteObject problem in For-Next loop DataMiner Modules & VBA 2 09-18-2002 10:30 PM




All times are GMT -8. The time now is 12:34 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World