Access 2010 Mouse Over Make Table Query

BartWestphal
BartWestphal used Ask the Experts™
on
When I "mouse over" or hover over a make table query name in Access 2003 (where it shows all of the Access Objects on the left side of the screen), it displays the name of the table that the query will make when run.  I've just installed Access 2010 and I've noticed that it shows the name of the query NOT the name of the table it will make when run.

Is there a setting to change to show the table name it will make (as in 2003)?  Otherwise to determine the name of the table the query will make, I have to go into Design View and Click on Make Table and it shows the name - that's MAJOR inconvenient while trying to review database flow/logic.

Thanks in advance.

- Bart
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Database Architect / Application Developer
Top Expert 2007
Commented:
Actually, it shows the query name followed  immediately by the table name

EG:
Query1TableOne
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
Top Expert 2007
Commented:
Similar for an Append Query ...

mx
mbizupNerd
Most Valuable Expert 2012
Top Expert 2013
Commented:
Are these queries in a converted Access 2003 database?

That could be the problem...

If I create a Make Table query in Access 2010, hovering over the query name DOES display the name of the table, combined with the query name like this:

          qryMyQuerytblTargetTable
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
Top Expert 2007

Commented:
:-)

Author

Commented:
I feel ashamed.  I usually call my queries something like:
4b - Pull Product Information
With the number/letter combo signifying order to run and the "Product Information" part of the query name being the name of the table I'm creating.  But this can change if it's more complex (hence the need to be able to mouse over).

I must have missed the whole string since the table name starts immediately after the query name.

Live and learn I guess.  Thanks for the help.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial