Opening a Macro in Design View

[jkwok]

Hi,

I have several macros, and usually in haste I will double click on the macro and run it whereas I just wanted to open it in design view. I remember being able to change a setting somewhere so that a double-click on a macro will open in design view instead of actually running the macro.

I've looked all over access and can't find out how to do this. I know it's possible, or at least it was in the Office 97 version when I was in school.

It's a rather simple and silly thing to ask for, but I'd really appreciate it!

Thanks,
Jason

[ADezii]

Hi,

I have several macros, and usually in haste I will double click on the macro and run it whereas I just wanted to open it in design view. I remember being able to change a setting somewhere so that a double-click on a macro will open in design view instead of actually running the macro.

I've looked all over access and can't find out how to do this. I know it's possible, or at least it was in the Office 97 version when I was in school.

It's a rather simple and silly thing to ask for, but I'd really appreciate it!

Thanks,
Jason

I'm not sure, but I sense that you are thinking of something similar but definitely not related. You can modify the Default mechanism for Opening an Access Object in the Database Window to Single-Click via:

1. Tools
2. Options
3. View
4. Click Options in Database Window
   1. o Single-Click Open
   2. o Double-Click Open
5. If I am incorrect I apologize. I do not, however, know of any option that will Open a Macro in Design View with a Double-Click short of fancy API Calls.

[jkwok]

Hi ADezii,

I'll try that. I remember learning access in university, and the prof showed us a way to make macros open in design view instead of simply running. This was several years ago though, in Access 97, so perhaps that feature was laid to rest a long time ago?!

Thanks anyway!

Jason

[kiwijim]

Here ya go

DoCmd.SelectObj ect acMacro, "MACRO NAME", True
DoCmd.RunComman d acCmdDesignObje ct

[isladogs]

Thanks for responding but do you realise this thread is 14 years old!