Question Show All Actions in Macro Design

[chuckcoleman]

Is there a way to make the Show All Actions the default, (vs. just the Action Catalog), when you are in the design mode for a macro? It seems like I always need something in the Show All Actions and it's an extra step to always have to click on it. Thanks! Chuck

 

[AccessJunkie]

Hi Chuck,

Unfortunately, I don't think this is possible. Whenever you come into the macro design surface, the Show All Actions button won't be selected.

Let me ask a follow-up question. Which "unsafe" macro actions are you typically using? Perhaps understanding your scenarios will help us to determine whether we should make some of those unsafe actions safe instead.

Thanks,

--------------------
Jeff Conrad - Access Junkie - MVP Alumnus
SDET II - Access Test Team - Microsoft Corporation

Author - Microsoft Access 2010 Inside Out
Co-author - Microsoft Office Access 2007 Inside Out
Access 2007/2010 Info: http://www.AccessJunkie.com

----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
----------

 

[chuckcoleman]

Jeff, SetValue is the most common one.

 

[AccessJunkie]

Hi Chuck,

Thanks for the additional information.

If you're using Access 2010, which it sounds like you are, instead of using the non trusted SetValue macro action, use the trusted SetProperty macro action instead. You won't have to worry about running this in an untrusted environment.

In 2010, drop a SetProperty macro action onto the macro design surface and you'll see three arguments - Control Name, Property, and Value. In the Control Name argument, enter the control you want to write to. For the Property argument, select the Value option. In the Value argument, enter the expression or data you want to write to that control.

--------------------
Jeff Conrad - Access Junkie - MVP Alumnus
SDET II - Access Test Team - Microsoft Corporation

Author - Microsoft Access 2010 Inside Out
Co-author - Microsoft Office Access 2007 Inside Out
Access 2007/2010 Info: http://www.AccessJunkie.com

----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
----------