By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,847 Members | 3,081 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,847 IT Pros & Developers. It's quick & easy.

Opening a Macro in Design View

P: 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
Share this Question
Share on Google+
2 Replies


ADezii
Expert 5K+
P: 8,616
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

P: 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

Post your reply

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