DeleteObject not found? (1 Viewer)

AC5FF

Registered User.
Local time
Today, 03:46
Joined
Apr 6, 2004
Messages
552
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
 
Last edited:

RogerCooper

Registered User.
Local time
Today, 01:46
Joined
Jul 30, 2014
Messages
277
Did you click "Show All Actions" on the "Design" tab?
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 16:46
Joined
May 7, 2009
Messages
19,169
Yup, just check on
my A2016 x64, its there alright.

you an use SQL query to delete the table:

DoCmd.RunSQL "Drop Table tableName;"
 

AC5FF

Registered User.
Local time
Today, 03:46
Joined
Apr 6, 2004
Messages
552
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!
 

Users who are viewing this thread

Top Bottom