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