Macros in Access 2007

[vic]

Hello,

I have a database ported from Access 2002 to Access 2007 and I cannot figure
out how to go to a specific macro and either edit it or rename it. Pressing
Macro on the Ribbon I get a design page for creating a new macro but how do
I edit an existing macro. The only thing I'm able to do is create or run a
macro.


Thanks,

Vic

 

[AnandaSim]

Display the navigation pane if it is not showing. Single click on the
macro with the mouse. Ctrl+Enter on the Macro or Right Click on the
Macro will take you to edit it.

 

[vic]

Display the navigation pane if it is not showing. Single click on the
macro with the mouse. Ctrl+Enter on the Macro or Right Click on the
Macro will take you to edit it.

Ananda,

Thanks, displaying the Navigation Pane was the secret!

Now, is there a way to always show the navigation pane. When my app starts
up and shows my startup form the navigation pane is then hidden. I have to
hold the shift down to start the app and the navigation pane shows where I
can edit any of the database objects.

Thanks,

Vic

 

[vic]

Display the navigation pane if it is not showing. Single click on the
macro with the mouse. Ctrl+Enter on the Macro or Right Click on the
Macro will take you to edit it.

Ananda,

Never mind - the key F11 will toggle the Navigation Pane.


Vic

 

[ksf123]

Hello,

I have a database ported from Access 2002 to Access 2007 and I cannot
figure
out how to go to a specific macro and either edit it or rename it.
Pressing
Macro on the Ribbon I get a design page for creating a new macro but how
do
I edit an existing macro. The only thing I'm able to do is create or run
a
macro.


Thanks,

Vic