Link to home
Start Free TrialLog in
Avatar of Rayne
RayneFlag for United States of America

asked on

Access ShortCut PLEASE

Hello All,

i end up several times going to query designer and start writing up my own sql (instead of using the query wizard or choosing tables from the menu to add to the query designer. What is the shortcut t that will directly open a blank query window where I could directly start writing sql?

I am asking because I end doing this so often that i think it will make sense to use a shortcut to directly open a new blank query window like attached

Thank you
queryBlankWindwo.jpg
Avatar of Rayne
Rayne
Flag of United States of America image

ASKER

like a ctrl + N ? not sure for new query?
Avatar of Dale Fye
I'm not aware of there being a keyboard shortcut.

I looked to see whether there is an icon you can add to the Quick Access Toolbar but it does not appear to be an option there either.  I also looked through the RunCommand constants, and I don't see one that could be used to do this.

You could create a query, something like "SELECT * FROM SomeTable", change it over to SQL view, and then save it.  When you need a new query, simply right click on it in the navigation bar and select Design.  That's about as close to what you are looking for as I can think of.
ASKER CERTIFIED SOLUTION
Avatar of Richard Francis
Richard Francis

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Richard,

I've never been a fan of SendKeys, can you please interpret what that function says?

Dale
Avatar of Richard Francis
Richard Francis

Hi Dale,

No problems:

%C
Selects the "Create" tab on the ribbon.

QD
Opens a new query in design view.

%C
Closes the "Show Table" dialog.

%JQ
Selects the "Design" tab on the ribbon.

W
Selects the "View" drop down

Q
Selects "SQL View"

I tested this in Access 2010 and it worked for me.

I haven't used sendkeys much and there may be reasons not to use it. I'm not aware of any, but it's not a topic that's covered in any great detail in the material I've read.

Richard.
Just wanted to kick in that send keys is it...there's no shortcut I'm aware of either.

No points please.

Jim.
Avatar of Rayne

ASKER

This is a HUGE lifesaver. Thank you for your brilliance :)
Thank you a million
Avatar of Rayne

ASKER

thank you again :)
Avatar of Rayne

ASKER

4-4 clicks reduced to one click, awesome
No problems, glad to help.

It was my first post too.