Set SQL View as default in Access 2007

[Bill Nevin]

I was wondering if it's possible to avoid "Design View" completely when
developing a query. I'm a fairly seasoned developer (outside of Access) and I
have a solid SQL background. I know I can simply select "SQL View" from the
drop down, the problem I have is that from "Table View," the default button
in the ribbon is back to "Design View" while "SQL View" remains an alternate
option in the drop down. The only time "SQL View" is standard is when you use
a Union or something else too complex for "Design view." I was wondering if
it was possible to have the standard button in the ribbon switch from Table
and SQL View always and have "Design View" as an alternate option in the drop
down. I didn't see anything in the options and settings.

Thanks.

 

[Tom van Stiphout]

On Wed, 21 Jan 2009 20:34:00 -0800, Bill Nevin

The closest I could get to your requirements was to create an AutoKeys
macro:
{F12} RunCode myF12Handler

And in a standard module:
Public Function myF12Handler()
Application.RunCommand acCmdSQLView
End Function

Then hit F12 to switch to SQL view.

-Tom.
Microsoft Access MVP

 

[Sylvain Lafontaine]

You can add it to your Quick Access Toolbar; will do the same:

Right-click on the menu: Customize Quick Access toolbar | Change "Popular
Commands"
to "All Commands" | select "SQL View" and [Add >>] it to the right.

 

[Bill Nevin]

That's one solution. I considered this myself, actually, but I was trying to
avoid work-arounds. The best piece of information you gave me was the fact
that this was the closest you can get me. I guess Access 2007 doesn't allow
this and a work-around is inevitable.

Thanks.

 

[RoyVidar]

I was wondering if it's possible to avoid "Design View" completely
when developing a query. I'm a fairly seasoned developer (outside of
Access) and I have a solid SQL background. I know I can simply
select "SQL View" from the drop down, the problem I have is that
from "Table View," the default button in the ribbon is back to
"Design View" while "SQL View" remains an alternate option in the
drop down. The only time "SQL View" is standard is when you use a
Union or something else too complex for "Design view." I was
wondering if it was possible to have the standard button in the
ribbon switch from Table and SQL View always and have "Design View"
as an alternate option in the drop down. I didn't see anything in
the options and settings.

Thanks.

I don't have anything except workarounds either.

Shortcuts Ctrl+. (period) and Ctrl+, (comma), are shortcuts to switch
between views in the different objects in the Access UI.

From design view, Ctrl and then two hits on period, should give you
SQL view (Ctrl+LeftArrow/Ctrl+RighArrow is also supposed to do the
same).