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
RayneAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

RayneAuthor Commented:
like a ctrl + N ? not sure for new query?
0
Dale FyeCommented:
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.
0
Richard FrancisCommented:
I don't think there's an option to set the default opening state for a query. However you could create a function, a macro to run that function and then add the macro to your quick ribbon toolbar.

For the function you could use sendkeys e.g.

Public Function sendMyKeys()
    
    sendkeys "%CQD%C%JQWQ"
        
End Function

Open in new window


then set up a runcode macro for that function.

This might not be the best way of doing what you want, but it's the only way I can think of.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Dale FyeCommented:
Richard,

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

Dale
0
Richard FrancisCommented:
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.
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Just wanted to kick in that send keys is it...there's no shortcut I'm aware of either.

No points please.

Jim.
0
RayneAuthor Commented:
This is a HUGE lifesaver. Thank you for your brilliance :)
Thank you a million
0
RayneAuthor Commented:
thank you again :)
0
RayneAuthor Commented:
4-4 clicks reduced to one click, awesome
0
Richard FrancisCommented:
No problems, glad to help.

It was my first post too.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.