• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 358
  • Last Modified:

Pre 2007 - create a query on a selected table or query in the DB window

Pre-Access 2007, I could select a table or query, then click the query toolbar item. It would then open the query in design mode with the selected item already loaded in the query. Did they remove this shortcut process in 2007 +.
Is there a way to bring that feature back?

0
askolits
Asked:
askolits
  • 11
  • 7
1 Solution
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Toolbar item ... ?
Can you post a screen shot ?

mx
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Do you mean this:

see image ...

mx
Capture1.gif
0
 
pcelbaCommented:
This is not necessary now. You may simply open the query designer and drag any table into it by mouse from the list of available tables and queries.

And, as I see you are asking in FoxPro zone, then you may use Query Wizard in Visual FoxPro which very user friendly but obvious way how to create a query in VFP is to write SQL command directly.
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
"You may simply open the query designer and drag any table into it by mouse from the list of available tables and queries."

You can do that in Access also.

askolits - are you referring to the toolbar (A2003) in the image below?  If so, it appears that toolbar does not exist on the Navigation 'Pain'.

mx
Capture1.gif
0
 
askolitsAuthor Commented:
Opps didn;t mean to post in Fox pro. Sorry.

In the attached screen shot, you simply select a table, then click on the tollbar item at the top. This ceates a 'new' query in design mode with the query already loaded.

  Seelect Object and pick Query item Select OK New Query
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
ok ... that still works ... stand by
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Note in screenshot 3 that ... the Table I selected gets defaulted in the Wizard ...

mx
Capture1.gif
Capture2.gif
Capture3.gif
0
 
askolitsAuthor Commented:
pcelba:

That drag feature was also available in 2003 as well.

The problem is, it's abit of a pain to first go to the create menu group, select Query Design, Close the Show Table box that opens by default, select the object type from the database window list, scroll down to find the object ( I usually have over a hundred), then drag the object in.

With the old method it was 3 clicks.
0
 
askolitsAuthor Commented:
The idea is really to avoid the wizard. I just want it to go right to the 'query grid' as quickly as possible.
I actaully don't use the wizard.
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
"With the old method it was 3 clicks."
Can you summarize those .... ?

mx
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
I'm looking at the Customize ribbon (below) ... and I don't specifically see a 'New Object' item that can be added ....

mx
Capture1.gif
0
 
askolitsAuthor Commented:
Look the screen shot for the three clicks.
0
 
askolitsAuthor Commented:
I was looking to see if I could modify the Right-Click shortcut for Tables or queries and could add a 'create query' item. But not sure if those can be modified. You used to be able modify those shortcuts. They took a lot of that away with 2007.
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Well, you can do it with 2 clicks and a 1 drag & drop operation in A 2010 (and prior)
Beyond that ... not sure what else I can add ...

mx
0
 
askolitsAuthor Commented:
Well, I'll have to live with it.
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
2 clicks + DnD ... how bad can that be ?

mx
0
 
askolitsAuthor Commented:
Maybe I'm just getting old and set in my ways. Although, I'd love to have the old database window back. Hate having to scroll up and down all the time and sorting by doing a few clicks. It was so much better before.
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
I hear you ... and others do too :-)

mx
0

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

  • 11
  • 7
Tackle projects and never again get stuck behind a technical roadblock.
Join Now