Show all Macro Actions

[Snowflake68]

The 'Show all Macro Actions' button wont expand even though it is enabled (it is not greyed out, see screenshot attached). It doesn't work for any of my existing databases nor any new ones created.

I am using Access 2013 and is was working up until recently but I dont know when this started as I dont use Macros too often. But I am updating an existing application that has a lot of actions in one of its macros that I would rather not have to rewrite in VBA.

I have enabled all macros in the Trust Centre but this still does not work. does anyone have any Ideas?

 

[Minty]

Trying opening the database as Administrator if you aren't currently.

It's a toggle - so are you sure the actions aren't just silently appearing on the designer window on the right - you just can't see them as nothing is opened?

 

[Snowflake68]

Trying opening the database as Administrator if you aren't currently.

It's a toggle - so are you sure the actions aren't just silently appearing on the designer window on the right - you just can't see them as nothing is opened?

Thanks Minty. Think I must be having a blonde moment today. God knows what I expected it to do when I clicked on it. Of course its a toggle stupid me :banghead:

All is working as it should. Still hungover from new year me thinks

 

[isladogs]

I rarely use macros either but when you say it doesn't work what do you mean?

The Action Catalog button should produce a list of items available
The Show All Actions button only affects databases in non trusted locations.
By default this is 'off' and in that case a shortened list of actions is available.
However I've never used this feature

 

[Pat Hartman]

macros that I would rather not have to rewrite in VBA.

Try the macro conversion option on the menu. The code generated is generally poor but it beats having to deal with macros.