[AccessD] Macros in 2007 - SOLVED

Kathryn,

Double-clicking a query will open the query's datasheet, or run it if it is 
an action query.  Double-clicking a report will open it in Print Preview or 
Report view (whatever is the default).  So it seems to me that the 
right-click will be the best approach to the design view of these objects as 
well.  In other words, macros are no different.

Regards
Steve


--------------------------------------------------
From: "Kathryn Bassett" <kathryn at bassett.net>
Sent: Saturday, March 06, 2010 5:10 PM
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] Macros in 2007 - SOLVED

> Thanks a bunch. I never thought about right clicking. I kept trying to
> double click like I do for queries and reports.
> Kathryn
>
>> -----Original Message-----
>> From: accessd-bounces at databaseadvisors.com [mailto:accessd-
>> bounces at databaseadvisors.com] On Behalf Of Steve Schapel
>> Sent: Friday, March 05, 2010 11:16 AM
>> To: Access Developers discussion and problem solving
>> Subject: Re: [AccessD] Macros in 2007
>>
>> Kathryn,
>>
>> The macro editing window in Access 2007 does look a bit different, but
>> is
>> basically the same concept.
>>
>> I would normally get to it by right-clicking the macro in the
>> Navigation
>> Pane, and then select Design View from the pop-up menu.
>>
>> Regards
>> Steve
>>
>>
>> --------------------------------------------------
>> From: "Kathryn Bassett" <kathryn at bassett.net>
>> Sent: Saturday, March 06, 2010 7:52 AM
>> To: "'Access Developers discussion and problem solving'"
>> <accessd at databaseadvisors.com>
>> Subject: [AccessD] Macros in 2007
>>
>> > I just tried to edit a macro for the first time since I've been in
>> 2007
>> > and
>> > can't figure out how to open it for editing. 2003 was easy as it
>> opened a
>> > spreadsheet type window and I could add commands to it. The existing
>> > autoexec macro is simplistic in that it maximizes the window (that's
>> all
>> > it
>> > does). But I want to have it open a particular form as well. How do I
>> open
>> > it to edit?
>> >