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?

askolitsAsked:
Who is Participating?
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Connect With a Mentor Database ArchitectCommented:
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
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Toolbar item ... ?
Can you post a screen shot ?

mx
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Do you mean this:

see image ...

mx
Capture1.gif
0
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

 
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
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
"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 Access MVP)Database ArchitectCommented:
ok ... that still works ... stand by
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
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 Access MVP)Database ArchitectCommented:
"With the old method it was 3 clicks."
Can you summarize those .... ?

mx
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
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
 
askolitsAuthor Commented:
Well, I'll have to live with it.
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
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 Access MVP)Database ArchitectCommented:
I hear you ... and others do too :-)

mx
0
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.

All Courses

From novice to tech pro — start learning today.