Rayne
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
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
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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Richard,
I've never been a fan of SendKeys, can you please interpret what that function says?
Dale
I've never been a fan of SendKeys, can you please interpret what that function says?
Dale
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.
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.
No points please.
Jim.
ASKER
This is a HUGE lifesaver. Thank you for your brilliance :)
Thank you a million
Thank you a million
ASKER
thank you again :)
ASKER
4-4 clicks reduced to one click, awesome
No problems, glad to help.
It was my first post too.
It was my first post too.
ASKER