470,596 Members | 1,215 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,596 developers. It's quick & easy.

Opening a Macro in Design View

32
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
Mar 18 '08 #1
4 14463
ADezii
8,801 Expert 8TB
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.
Mar 18 '08 #2
jkwok
32
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
Mar 19 '08 #3
kiwijim
1 Bit
Here ya go

DoCmd.SelectObject acMacro, "MACRO NAME", True
DoCmd.RunCommand acCmdDesignObject
Jan 19 '22 #4
isladogs
352 Expert Mod 256MB
Thanks for responding but do you realise this thread is 14 years old!
Jan 20 '22 #5

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by Hank | last post: by
9 posts views Thread by Dixie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.