Command button action

[Guest]

I'm using Access 2003 and would like to set up a form with one of the command
buttons that opens an existing macro in design (edit) view. Using the
Command Button Wizard, there isn't an action that does this (only 'Run
Macro'). Is there a way to open a macro in design (edit) view using a form
command button ('On Click' property)? Or, is there another way to accomplish
this action? Thanks for your assistance.

 

[Steve Schapel]

Bill,

No, as far as I know this is not possible.

Why do you want to do this?

 

[Guest]

I'm going to be out of the office for ~3 weeks and I'm attempting to simplify
navigating around Access using command buttons (for my 'backup'). I know the
"danger" of turning it over to someone not too familiar with Access but
that's what the boss said to do. (When I return, I expect to find a little
slice of chaos.) Thanks for your reply.

 

[Steve Schapel]

Best wishes, Bill. It is an excellent idea to build in some simplified
navigation, via macros under command buttons. No argument there.
However, I can't think why you would need your backup person to have
access to the design of these macros.