[AccessD] weird query def

John Colby jcolby at colbyconsulting.com
Mon Jun 30 13:11:55 CDT 2003


Checked the properties for one that works and this one that doesn't and they
are identical.

John W. Colby
www.colbyconsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Steve
Capistrant
Sent: Monday, June 30, 2003 1:20 PM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] weird query def


Does your query have "output all fields" property set to Yes?  The QBD view
for these queries could show no fields, yet you'd still get results.

Steve Capistrant
Symphony Information Services
scapistrant at symphonyinfo.com
Phone: 612-333-1311
www.symphonyinfo.com
212 3rd Ave N, Ste 404
Minneapolis, MN 55401


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of John Colby
Sent: Monday, June 30, 2003 11:58 AM
To: AccessD
Subject: [AccessD] weird query def


I have a weird one.  I am opening a query def and reading all of the field
names out into a comma delimited string to use as a row source for a combo.
All that stuff works.  One of the queries in the db I am trying to work on
says it has NO fields.  If I execute the query I get data.  If I look at the
querydef itself, I can see the name of the query, the SQL property, etc.
But ask it for the .Fields.Count and it comes back 0.

Very unsettling since I need to use this method for displaying field names
to the user to select to match against document book marks in a mail merge
wizard.

I compacted / repaired both the wizard as well as the FE that actually holds
the query in question.  Two other queries that I am performing this
operation on work perfectly.  One apparently has no fields.

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





More information about the AccessD mailing list