Link to home
Start Free TrialLog in
Avatar of askolits
askolits

asked on

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?

Avatar of DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Flag of United States of America image

Toolbar item ... ?
Can you post a screen shot ?

mx
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.
"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
Avatar of askolits
askolits

ASKER

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.

  User generated image User generated image User generated image
ok ... that still works ... stand by
Note in screenshot 3 that ... the Table I selected gets defaulted in the Wizard ...

mx
Capture1.gif
Capture2.gif
Capture3.gif
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.
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.
"With the old method it was 3 clicks."
Can you summarize those .... ?

mx
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
Look the screen shot for the three clicks.
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.
ASKER CERTIFIED SOLUTION
Avatar of DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Flag of United States of America image

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
Well, I'll have to live with it.
2 clicks + DnD ... how bad can that be ?

mx
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.
I hear you ... and others do too :-)

mx