[AccessD] Query SQL correct but not visible in design view

Hale, Jim Jim.Hale at FleetPride.com
Mon Dec 27 10:41:29 CST 2004


Do you use foreign key field names that are  different from the primary key
name in the parent tables? What sort of naming convention do you use? I
always find it easier to understand a database  when I can track fields such
as fldFirstName throughout a table structure. However, I must confess I
don't religiously follow this naming convention myself.
Jim Hale

-----Original Message-----
From: John W. Colby [mailto:jwcolby at colbyconsulting.com]
Sent: Saturday, December 25, 2004 12:40 PM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Query SQL correct but not visible in design view


That would explain it.  I do not use the table qualifier unless the field
name is the same in different tables which is generally not the case in my
systems.

John W. Colby
www.ColbyConsulting.com 

Contribute your unused CPU cycles to a good cause:
http://folding.stanford.edu/

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of A.D.Tejpal
Sent: Saturday, December 25, 2004 12:23 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Query SQL correct but not visible in design view


John,

    If an SQL statement is put directly in SQL view of QBE,  without having
first dragged any field into the QBE grid, relevant fields get displayed in
the grid only if their names in  SELECT clause are qualified by the table
name.

    For example -
    (a) SELECT *  FROM  tbl1 - will not show any field in QBE grid.
    (b) SELECT  tbl1.*  FROM  tbl1 - will result in correct display in QBE
grid.

    Note - This is as per tests conducted on Access XP running on Win XP.

A.D.Tejpal
--------------

  ----- Original Message ----- 
  From: John W. Colby 
  To: 'Access Developers discussion and problem solving' 
  Sent: Friday, December 24, 2004 09:04
  Subject: [AccessD] Query SQL correct but not visible in design view


  I am building a SQL statement "on the fly" which essentially compares
matching fields in two different tables - Tbl1.Lname <> Tbl2.Lname.  The SQL
runs but only the tables and their joins are visible in the QBE grid.  There
are no fields visible etc.  Does anyone understand what causes Access to do
  this?  
  I have had the same thing occur even with something as simple as a SELECT
* from tbl1 inserted into the SQL view.  Tbl1 is displayed, but nothing in
the grid.  The query executes correctly.

  Anyone?

  John W. Colby
  www.ColbyConsulting.com 
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

***********************************************************************
The information transmitted is intended solely for the individual or
entity to which it is addressed and may contain confidential and/or
privileged material. Any review, retransmission, dissemination or
other use of or taking action in reliance upon this information by
persons or entities other than the intended recipient is prohibited.
If you have received this email in error please contact the sender and
delete the material from any computer. As a recipient of this email,
you are responsible for screening its contents and the contents of any
attachments for the presence of viruses. No liability is accepted for
any damages caused by any virus transmitted by this email.


More information about the AccessD mailing list