What replaced the deleteobject marco action in Access 2007?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rob C - 21 Sep 2007 19:52 GMT

In the older verison, when writing a macro I used to have the option
DeleteObject. Does anyone know what replaced it or where it is hiding?
(I used DeleteObject to delete tables & then replace them - I have found a
work around, write a delete query to delete the data & then an append query)

Reply to this Message

Steve Schapel - 21 Sep 2007 21:57 GMT

Rob,

I would expect that your "workaround" is in fact the way most people
would do it anyway. :-)

It sounds like you need to click the 'Show All Actions' button under
Macro Design Tools on the Ribbon.

Signature

Steve Schapel, Microsoft Access MVP

> In the older verison, when writing a macro I used to have the option
> DeleteObject. Does anyone know what replaced it or where it is hiding?
> (I used DeleteObject to delete tables & then replace them - I have found a
> work around, write a delete query to delete the data & then an append query)

Reply to this Message